what is the use of ondelete cascade?
Answers were Sorted based on User's Feedback
Answer / ajeet singh
"on delete cascade" is a deleting prodess in which,if we
delete any record from the table,then all records related
to this record are deleted which are exist in any other
related/foreign table.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / deva
on delete cascade is used to delete the rows/constraints
which are in integrity/foreign key constraints.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / nanne
On Delete cascade is used to when we delete the record from parent table then the related/derived record also deleted from child table.
Regards,
Nanne
| Is This Answer Correct ? | 1 Yes | 0 No |
Can we store pictures in the database and if so, how it can be done?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What is the difference between online and offline backups?
How to create tables for odbc connection testing?
what are steps for interface? where is exchange rate defined in which table?
How to create a new user account in oracle?
What is Data Block ?
how to insert the image in table
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
what is the syntax of UPDATE command?
Explain the use of record option in exp command.
What are the differences between date and timestamp in oracle?