stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_ENUM_STCW_REF_TYPE_ID_SEQ
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_ENUM_STCW_REF_TYPE_ID_SEQ" before insert on "ENUM_STCW_REFERENCE_TYPE" for each row begin if inserting then if :NEW."ENUM_STCW_REFERENCE_TYPE_ID" is null then select ENUM_STCW_REFERENCE_TYPE_SEQ.nextval into :NEW."ENUM_STCW_REFERENCE_TYPE_ID" from dual; end if; end if; end;