CREATE SEQUENCE test_sequence
START WITH 1
INCREMENT BY 1;
2. create trigger
CREATE OR REPLACE TRIGGER (trigger_name)
BEFORE INSERT ON (table_name)
REFERENCING NEW AS N
FOR EACH ROW
BEGIN
SELECT (sequence_name).nextval INTO :N.(column_name) FROM dual;
END;