PL/SQL (MOSC)

MOSC Banner

trigger predicate

edited Jan 3, 2013 9:15PM in PL/SQL (MOSC) 3 commentsAnswered
i have two tables.
CREATE TABLE SUPPLIER
(
AGREEMENT_ID NUMBER(8) NOT NULL,
SUPPLIER_ID NUMBER(8) NOT NULL,
LAST_UPDATE_DATE DATE,
LAST_UPDATE_PERSON_ID INTEGER
);

CREATE TABLE SUPPLIER_TRANSACTION
(
AGREEMENT_ID NUMBER(8) NOT NULL,
SUPPLIER_ID NUMBER(8) NOT NULL,
LAST_UPDATE_DATE DATE,
LAST_UPDATE_PERSON_ID INTEGER,
comments VARCHAR2(250)
);

i want to track all the records -
1)if a record insert into SUPPLIER TABLE it also insert into SUPPLIER_TRANSACTION for tracking record inserted(comments).
2)while update supplier id into SUPPLIER TABLE it also insert old value from supplier to SUPPLIER_TRANSACTION for tracking record was updated(comments).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center