How to copy a record into other table in a trigger
579029May 23 2007 — edited May 25 2007Hi
I am new PL/SQL programmer. Need to do next
When user table add a new record or update, copy the record and modify time to a backup table.But I don't know table structure (column name, type etc.).
So first need to create a procedure that can create back table for every table (or view). The structure is original table + date.
Second I must create a trigger can copy a record that be add or updated to this backup table.
I can not do "insert into XXX VALUES( :new.id,:new.name, sysdate);". Column name should be parameters.
Any idea, example will very helpful.
Thanks first!