CREATE SEQUENCE SQ_W_ACCOUNT INCREMENT BY 1 START WITH 1 MAXVALUE 999999999999 CYCLE NOCACHE;
CREATE TRIGGER W_ACCOUNT_TG
BEFORE INSERT ON W_ACCOUNT
REFERENCING
NEW AS new
OLD AS old
FOR EACH ROW
BEGIN
SELECT SQ_W_ACCOUNT.NEXTVAL INTO :NEW.ID FROM DUAL;
END;