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 |
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
Is oracle a language?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
What are the differences between date and timestamp in oracle?
What are the different pseudo commands? Explain in general?
What is an oracle database?
How to use regular expression in pattern match conditions in oracle?
What are the Limitations of a CHECK Constraint ?
What are set operators?
what is the syntax of DELETE command?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??