create sequence SEQ_GG_ZD_DP
minvalue 1
start with 1
increment by 1
nocache;
---------------------------------------------------------------------------
create or replace trigger TRI_GG_ZD_DP before insert on GG_ZD_DP
for each row
begin
select SEQ_GG_ZD_DP.nextval into :new.ID from dual;
end;
分兩次,在SQL/PLUS中執行,觸發器,用來對自增值進行觸發