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!

Database Trigger old and new values

415196Sep 23 2005 — edited Sep 23 2005

Hi,

I am writing a database update trigger on table A for each row trigger which contains WHEN
(NEW.INTV_CODE <> OLD.INTV_CODE)

In this same trigger i have to join trigger with other tables(B,C) and i have to selecting some columns of base table A which is not include in WHEN condition

What i have to select :new.column or :old.column of old tables to reference values which are not updated.

I think this information is enough to resolve problem. Please feel free to ask more explanations

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2005

Added on Sep 23 2005

8 comments

855 views