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 |
how to find full database size
1 Answers BirlaSoft, Consultancy,
How to fetch the row which has the max value for a column?
candidate key is subset of super key but not vice-verse explain
How to retrieve data from an cursor to a record?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
Use of an integrity constraint is better to validate data. Explain
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What are the common oracle dba tasks?
what is cartesian product?
What is the function of Redo Log ?
Can we save images in a database and if yes, how?