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 the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Briefly explain what is literal? Give an example where it can be used?
What is a cognitive schema?
How to bring a tablespace offline?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
What is oracle instant client?
How to find no of saturdays in a month using single sql ?
What is a data dictionary and how can it be created?
What is an Index ?
What is the implicit cursor in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?