GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQbind variables in triggers
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
Sponsored Links
Read Next: how to avoid outer joins
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
