华少少华

BlogJava

0 Posts :: 9 Stories :: 0 Comments :: 0 Trackbacks

Create Sequence Sequence_Name //建序列

Increment By 1 //增加为1

Start With 1 //开始为1

Maxvalue 99999999 //最大

Create Trigger Trigger_Name //创建触发器

Before Insert On Table_Name //条件

For Each Row //

Begin

select Sequence_Name.nextval into :new.ID from dual; //ID加1

end;

posted on 2007-11-09 21:07 华少阅读(639) 评论(0) 编辑收藏所属分类: 数据库