DROP SEQUENCE SEQ1
CREATE SEQUENCE SEQ1
INCREMENT BY 1
START WITH 1
MAXVALUE 999999999999;
DROP TRIGGER SET_ID
CREATE OR REPLACE TRIGGER SET_ID
BEFORE INSERT ON table
FOR EACH ROW
DECLARE
ID number;
BEGIN
SELECT SEQ1.nextval INTO ID FROM dual;
:NEW.ID:= ID;
END;