Tech Tutorials Database
GeekArticles FAQ Oracle FAQ
 

bind variables in triggers

 
Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

CREATE OR REPLACE TRIGGER dd before delete on table1nfor each rowndeclarenbeginn insert into table2 select :old.* from table1;nend;n/nnnThat is i want insert the date into table2 what ever deleted in table1.nnplz find the solution for me

Read More...




Sponsored Links




Read Next: how to avoid outer joins



 

 

Comments