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 truncate date and get only time part 9:20:00
Find all employees in Dept “Marketing”.
How many anonymous blocks can be defined?
Is there any function in oracle similar like group_concat of mysql?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How do I uninstall oracle client from windows?
how do u setup a replication site?
What are set operators?
What is a trace file and how is it created in oracle?
How to create a new user account in oracle?
What are the set operators union, union all, minus & intersect meant to do?