Newer
Older
EMS_SZ / SQL / V0_0_123__ACCIDENT_TRI.sql
root on 15 Jun 2016 175 bytes final
create or replace TRIGGER accidentit
BEFORE INSERT ON accident
FOR EACH ROW

when (NEW.DBID IS NULL)
BEGIN
    SELECT SEQ_ACCIDENT_ID.NEXTVAL INTO:NEW.DBID FROM DUAL;
    END;