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!

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,485 views