SynJay
--------------------------------------------------------------------------------知我者谓我何忧,不知我者谓我何求; 浮萍飘泊本无根,落拓江湖君莫问! It is not how you play the game. It is how the game plays you! 接受我喜欢的人,避开我不喜欢的人;被喜欢的人接受,被不喜欢的人避开!

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;

                                                                                                                                     666.jpg
分两次,在SQL/PLUS中执行,触发器,用来对自增值进行触发

posted on 2005-09-13 21:56 杰人天下 阅读(1160) 评论(0)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航:
 

<2005年9月>
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

常用链接

留言簿(3)

随笔档案

相册

收藏夹

网站资源链接

搜索

  •  

最新评论