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 is compilation error in pl sql?
What can you do with pl sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is the usage of the distinct keyword?
What is a clob in sql?
How does index help in query performance?
what is the difference between delete and truncate statement in sql? : Sql dba
Where do we use pl sql?
Is primary key clustered index?
How can we implement rollback or commit statement in a trigger?
How do you truncate?
What are different types of functions in sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Can we create table inside stored procedure?
What are the 3 modes of parameter?