Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

insert new row in another table based on update trigger on column value

N_RajAug 21 2019 — edited Aug 26 2019

Hi All,

We have oracle 11.2 on Redhat.

There is a task to capture column modifications.

We have the table test,which has 6 columns like column1,column2,column3,column4,column5 and status.

The status column has 2 values Y or N. When we insert the data,it always N, Monthly once we update to Y due to business reasons for few records.

Again we update from Y to N.

Whenever the status column updated from Y to N, we need to capture those rows and inserted into another table.

Can we do it by update trriger

Any suggestions

Thanks & Regards,

This post has been answered by L. Fernigrini on Aug 23 2019

Jump to Answer

Added on Aug 21 2019

#general-database-discussions

9 comments

7,212 views