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中执行,触发器,用来对自增值进行触发
posted on 2005-09-13 21:56
杰人天下 阅读(1160)
评论(0) 编辑 收藏