创建oracle的sequence 和 trigger

  -- Create sequence  NOMAXvalue
create sequence SEQ_ADMIN_ID
minvalue 1
maxvalue 99999999 //NOMAXvalue
start with 1
increment by 1
nocache
order;

-- Create trigger 
CREATE OR REPLACE TRIGGER trg_admin_id
BEFORE INSERT ON admin
FOR EACH ROW
BEGIN
SELECT  seq_admin_id.nextval INTO :new.id FROM dual;
END;