SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to copy existing row value into new row with a trigger. Same table

960914Sep 9 2012 — edited Sep 10 2012

Oracle guru,

I am looking for a before or after trigger statement that will copy existing values inserted in the previous row into columns A & B. Then insert those values in a new row into column A & B if null? Same table. Hopefully my question is clear enough.

-Oracle 10g express
-I have an existing " before insert trigger" that insert id and timestamps when a new row is created.
-Table is composed of column like id,timestamps,A,B and more.

Thanks in advance

Pierre

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2012

Added on Sep 9 2012

#pl-sql

7 comments

750 views