Insert records to table2 when records are deleted in table1

Mar 21 2013 7:20 AM

How to write a procedure for Inserting corresponding records to table2 when records are deleted in table1

Both table has same primary key column named :- ID

Note: Delete transaction will not place by passing parameters in procedure
even if a record is deleted in command prompt it should do the same.Give me Ideas as soon as
possible

Answers (1)

Example of After Insert Trigger in Oracle

How to get same columns with alias based on another column