I have a bulk load that is updating a table. there is a trigger on the table which fires and updates a "history" table in another schema.
My question is: When this trigger fires does the entire row get updated or only the where condition fields in the row?
CREATE OR REPLACE TRIGGER "U_CASHEXPECTEDENTRY"
AFTER UPDATE OF ACTGMETHOD_ID,CASHAMNT,CAS
HEXPECTEDE
NTRY_ID,CA
SHONQUANTI
TY_DTM,CAS
HOUTSTANDI
NG,CASHREC
ONCASHTYPE
_ID,CASHRE
CONREASON_
ID,CREATED
_BY,CREATE
D_DTM,END_
REALEVENT_
DTM,EXPECT
EDPAYMENT_
DTM,EXPECT
ED_REALEVE
NT_DTM,LED
GERENTRY_I
D,LEDGERLI
NE_ID,LOT_
ID,MODIFIE
D_BY,MODIF
IED_DTM,PE
RCENTAGELE
DGERLINE,R
EALEVENTHI
ST_ID,REAL
EVENT_DTM,
RECONCILED
_REALEVENT
_ID,SECURI
TY_ID,SETT
LEMENT_DTM
ON "NIS1".CASHEXPECTEDENTRY
REFERENCING OLD AS OLD NEW AS NRW
FOR EACH ROW
BEGIN
IF :NRW.REALEVENT_DTM IS NOT NULL
THEN
UPDATE "NIS1H".CASHEXPECTEDENTRY
SET
END_REALEVENT_DTM = :NRW.REALEVENT_DTM
WHERE
CASHEXPECTEDENTRY_ID=:OLD.
CASHEXPECT
EDENTRY_ID
AND
REALEVENT_DTM = :OLD.REALEVENT_DTM AND
END_REALEVENT_DTM is NULL;
INSERT INTO "NIS1H".CASHEXPECTEDENTRY
(
ACTGMETHOD_ID,CASHAMNT,CAS
HEXPECTEDE
NTRY_ID,CA
SHONQUANTI
TY_DTM,CAS
HOUTSTANDI
NG,CASHREC
ONCASHTYPE
_ID,CASHRE
CONREASON_
ID,CREATED
_BY,CREATE
D_DTM,END_
REALEVENT_
DTM,EXPECT
EDPAYMENT_
DTM,EXPECT
ED_REALEVE
NT_DTM,LED
GERENTRY_I
D,LEDGERLI
NE_ID,LOT_
ID,MODIFIE
D_BY,MODIF
IED_DTM,PE
RCENTAGELE
DGERLINE,R
EALEVENTHI
ST_ID,REAL
EVENT_DTM,
RECONCILED
_REALEVENT
_ID,SECURI
TY_ID,SETT
LEMENT_DTM
)
VALUES
(
:NRW.ACTGMETHOD_ID,:NRW.CA
SHAMNT,:NR
W.CASHEXPE
CTEDENTRY_
ID,:NRW.CA
SHONQUANTI
TY_DTM,:NR
W.CASHOUTS
TANDING,:N
RW.CASHREC
ONCASHTYPE
_ID,:NRW.C
ASHRECONRE
ASON_ID,:N
RW.CREATED
_BY,:NRW.C
REATED_DTM
,:NRW.END_
REALEVENT_
DTM,:NRW.E
XPECTEDPAY
MENT_DTM,:
NRW.EXPECT
ED_REALEVE
NT_DTM,:NR
W.LEDGEREN
TRY_ID,:NR
W.LEDGERLI
NE_ID,:NRW
.LOT_ID,:N
RW.MODIFIE
D_BY,:NRW.
MODIFIED_D
TM,:NRW.PE
RCENTAGELE
DGERLINE,:
NRW.REALEV
ENTHIST_ID
,:NRW.REAL
EVENT_DTM,
:NRW.RECON
CILED_REAL
EVENT_ID,:
NRW.SECURI
TY_ID,:NRW
.SETTLEMEN
T_DTM
);
END IF;
END;
/
SHOW ERRORS;