what is the use of ondelete cascade?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

639


How do I manually uninstall oracle client?

512


Explain mutating triggers.

569


What are advantages of dateset in datastage?

1744


What happens to the current transaction if a ddl statement is executed?

574






Explain oracle’s system global area (sga).

617


What is merge statement used for?

561


How index is implemented in oracle database?

590


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1468


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1791


What is open database communication (odbc) in oracle?

544


Is oracle a programming language?

562


What is rowid and rownum in oracle?

538


What are the predefined tablespaces in a database?

554


Is java required for oracle client?

546