stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_STCW_REFERENCE_MDATE
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_STCW_REFERENCE_MDATE" BEFORE INSERT OR UPDATE OF STCW_REFERENCE_ID, ENUM_STCW_REFERENCE_TYPE_ID , CERTIFICATE_OF_COMPETENCY, STCW_REGULATION , EXT_INFO, VERSION_ID ON STCW_REFERENCE FOR EACH ROW BEGIN :new."MDATE" := SYSTIMESTAMP; END;