Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in different tables
with same structure
- 4 Answers
- 9419 Views
- I also Faced
- E-Mail Answers
Answer Posted / radha sri seshu.kolla
while creating table and giving foreign key constraint give
the key word 'on delete cascade'.automatically when the
record in the master table is delated the relaeted record
in the detail table will also be deleted.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what is the difference between where clause and having clause? : Sql dba
How do you break a loop in pl sql?
What are packages in pl sql and also explain its advantages?
What is difference between inner join and self join?
What is Difference Between Unique and Primary Key Constraints?
What is indexing oracle sql?
If a cursor is open, how can we find in a pl/sql block?
Is hadoop a nosql?
What is numeric function sql?
What is attribute indicator in pl sql?
Which certification is best for sql?
Explain the order of sql statement execution?
What are the 3 types of behavioral triggers?
Define overloaded procedure?
How can you create an empty table from an existing table?
