Answer Posted / tulsi
The main use of ON DELETE CASCADE is to delete the child
records automatically from a table when the related records
from master table is deleted.
Assign the ON DELETE CASCADE clause while creating the
foreign key
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What found sql?
What is %rowtype in pl sql?
What is the use of non clustered index?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
How do I save the results of sql query in a file?
What does the argument [or replace] do?
What are the built in functions of sql?
What is the importance of sqlcode and sqlerrm?
Is a secondary key the same as a foreign key?
What is data profiling in sql?
What is rownum?
What are the possible values for the boolean data field?
What is thread join () in threading?
How to run pl/sql statements in sql*plus?
How do you define a foreign key?