trigger to update a table whenever col status is changed in another table
hello,
Can anyone plz help me out with this issue.
I want to create a trigger which updates the TBL1 CHF_STATUS column and sets it to "DEV" whenever the CHF_STATUS column in TBL2 is
updated from "PRD" to "DEV" for that particular DATASTORE, SCHEMA, TABLE. Below are the table structures and their constraints.
CREATE TABLE TBL1
( "CHF_DATASTORE" VARCHAR2(100) NOT NULL ENABLE,
"CHF_SCHEMA" VARCHAR2(100) NOT NULL ENABLE,
"CHF_TABLE" VARCHAR2(100) NOT NULL ENABLE,
"CHF_STATUS" VARCHAR2(3),
"CHF_STATUS_DT" DATE,
CONSTRAINT "CHF_TABLE_PK" PRIMARY KEY ("CHF_DATASTORE", "CHF_SCHEMA", "CHF_TABLE") ENABLE
)
/
=================================================
CREATE TABLE TBL2
( "CHF_DATASTORE" VARCHAR2(100) NOT NULL ENABLE,
"CHF_SCHEMA" VARCHAR2(100) NOT NULL ENABLE,
"CHF_TABLE" VARCHAR2(100) NOT NULL ENABLE,
"CHF_COLUMN" VARCHAR2(100) NOT NULL ENABLE,
"CHF_BUSINESS_NAME" VARCHAR2(100),
"CHF_STATUS" VARCHAR2(3),
"CHF_STATUS_DT" DATE,
CONSTRAINT "CHF_COLUMN_PK" PRIMARY KEY ("CHF_DATASTORE", "CHF_SCHEMA", "CHF_TABLE", "CHF_COLUMN") ENABLE
)
/
Thanks,
Orton