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 |
What is Rollback Segment ?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
What happens if the update subquery returns multiple rows?
What are the varoius components of physical database structure of oracle database?
Explain the truncate in oracle?
How to add a new column to an existing table with a default value?
What is the difference between alert log file and trace file ?
How to check the server version in oracle?
how can we store any pdf file in oracle
After using set unused can we enable the column again to use? Please give me some answers....
What is Row Chaining ?
Explain the use of show option in imp command.