Oracle 建立 trigger 及 sequence 達成類 MySQL auto increment

sequence: 在 Oracle Developer 裡新增，
最大值 999999999999999999999999999
增量 1
NOCACHE
(其中習慣命名以_seq結尾；trigger 以 _tri 結尾)

Trigger:

CREATE OR REPLACE TRIGGER MEMBERS_TRI
BEFORE INSERT OR DELETE OR UPDATE ON MEMBERS
FOR EACH ROW
BEGIN
  SELECT MEMBERS_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;