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!

Creating a Trigger for Deleting the records from a parent Table

677689Dec 30 2008 — edited Dec 30 2008

I am new to creating Trigger

We will need several small tables that will be used to store any records that are deleted by the owner of the table. These will likely need a trigger where we would Delete from the parent table and on that Delete populate the child table with the previous record's data.

Please give me a pseudo code for this
Thanks
John

Edited by: user10750995 on Dec 30, 2008 9:06 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2009

Added on Dec 30 2008

1 comment

709 views