Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

THE following trigger can be used for RAAK-TRANS-DETAIL CREATE OR REPLACE TRIGGER  "RAAK-TRANS-DETAIL-BI" BEFORE

INSERT OR UPDATE on "RAAK-TRANS-DETAIL" for each row

begin

if :NEW,"RECORD-ID" IS NULL THEN

:NEW,"RECORD-ID" := RECORD-ID-SEQ,NExTVAL ; END IF;

end;

The following trigger will be created for balance-sheet table.

CREATE OR REPLACE TRIGGER "BI-BALANCE-SHEET" before insert on "BALANCE-SHEET"

for each row

begin

if :NEW."RECORD-ID" is null then

select "RECORD-ID-SEQ".nextval into :NEW."REC-ID" from dual;

end if;

end;

Trigger for Profit-loss table: