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 |
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What operating systems are supported by oracle database 10g xe?
What is translate in oracle?
Difference between cartesian join and cross join?
How to find out what oracle odbc drivers are installed?
How to create a server parameter file?
How many data types are supported?
what is candidate key & super key
How to export data with a field delimiter?
What is the relation of a user account and a schema?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What is the difference between PFILE and SPFILE in Oracle?