SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL on delete cascade.. ( how to view the child record deleted..?)

641320Jan 27 2010 — edited Feb 10 2010

Hai

i have 70 tables integrated with foreign and child key constraints. i have on delete cascade for all the child tables. if i delete the parent table automatically child table record get deleted.

Kindly tell me how can i check howmany child record has been deleted ..? how can i monitor this...?

one thing i can do... i can make count of child table before and after...

is there anyother way..?

S

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2010

Added on Jan 27 2010

8 comments

3,658 views