stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_LEGAL_REQUIREMENT_ID_SEQ
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_LEGAL_REQUIREMENT_ID_SEQ" before INSERT ON "LEGAL_REQUIREMENT" FOR EACH row BEGIN IF inserting THEN IF :NEW."LEGAL_REQUIREMENT_ID" IS NULL THEN SELECT LEGAL_REQUIREMENT_SEQ.nextval INTO :NEW."LEGAL_REQUIREMENT_ID" FROM dual; END IF; END IF; END;