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中执行，触发器，用来对自增值进行触发