|Subject:||Help on Insert Triggers|
|Date:||6 Nov 2005|
I am new to this group and my friends gave a great feedback. I need
help in writing Insert
triggers that would insert a record on a table, whenever a specific
record is deleted from another table. I am using Oracle 10g.
For eg. TableMain has columns ColId, ColName and ColDesc.
TableSecondary has same columns as TableMain.
I want to insert the same record in TableSecondary, that would be
deleted from TableMain
based on a condition.
Can someone Help and show me a link, that would help write triggers. I
would be writing
few more triggers in future.