create or replace TRIGGER PATROLERIT
BEFORE INSERT ON PATROLER
FOR EACH ROW

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