Newer
Older
EMS_SZ / SQL / V0_0_135__MARK_TASK_TRI.sql
root on 18 Jun 2016 181 bytes uodate sql
create or replace TRIGGER mark_taskit
BEFORE INSERT ON mark_task
FOR EACH ROW

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