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 are the differences between number and binary_float in oracle?
What are various constraints used in SQL?
What are the various constraints used in oracle?
List out the types of joins.
What is tns name?
What is BBED in Oracle?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
How you open and close a cursor variable.Why it is required?
What is a schema in oracle?
What is an oracle user account?
what are actual and formal parameters?
What is the purpose of a cluster?