Name Value
OWNER AREL
TRIGGER_NAME ST_DEPARTEMENTS
TRIGGER_TYPE BEFORE EACH ROW
TRIGGERING_EVENT INSERT
TABLE_OWNER AREL
BASE_OBJECT_TYPE TABLE
TABLE_NAME DEPARTEMENTS
COLUMN_NAME null
REFERENCING_NAMES REFERENCING NEW AS NEW OLD AS OLD
WHEN_CLAUSE null
STATUS ENABLED
DESCRIPTION st_departements BEFORE INSERT ON departements FOR EACH ROW
ACTION_TYPE PL/SQL
TRIGGER_BODY BEGIN SELECT s_departements.nextval INTO :new.p_id FROM dual; END;
CREATED 2011-09-02 09:27:08.0
LAST_DDL_TIME 2011-09-02 09:27:08.0