Oracle 里面创建唯一键值自动增长
CREATE OR REPLACE SEQUENCE SEQ_ID
START WITH 1
MAXVALUE 999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;
CREATE OR REPLACE TRIGGER TAB_A_Tri before insert on TAB_A for
each row
begin select SEQ_ID.nextval into :new.id from dual;
end;