create sequence sequence_name start with 1;
CREATE TRIGGER trigger_name
BEFORE INSERT
ON table_name
REFERENCING NEW AS N
FOR EACH ROW
DECLARE
id_rec NUMBER;
BEGIN
SELECT seq_name.NEXTVAL INTO id_rec FROM dual;
:n.field_name := id_rec;
END;