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 |
Describe Referential Integrity ?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
Is there an oracle sql query that aggregates multiple rows into one row?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What operating systems are supported by oracle database 10g xe?
What is the sql query to concatenate column values from multiple rows in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to check your oracle database 10g xe installation?
How would you design a database for an e-commerce website?
what is difference between foreign key and reference key
Will you be able to store pictures in the database?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>