-- 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;