Linux初探欢迎您的投稿，投放方法请点击
这里查看，我们会定期赠送精美小礼品给优秀的投稿作者。海纳百川 取则行远！LinuxGoo欢迎您的到来。
不管怎么说我刚学习那个oracle这个自增问题也是搜素了半天，才整理了这一篇完整的自增步骤及实例，希望能给遇到相同问题的仁兄仁妹帮助。。。建表：drop table UserInf......
') ;
----------------------------------------以上是创建步骤-------------------------------------------------------------------------------------------
drop table UserInfo ;
create table UserInfo(id number not null primary key ,
name varchar2(20) not null ,
age number not null,
sex varchar2(2) not null,
email varchar(100) not null,
ads varchar(50) not null);
drop sequence seq_id ;
create sequence seq_id
minvalue 0
nomaxvalue
start with 1
increment by 1;
create or replace trigger test_trigger
before insert on UserInfo
for each row
begin
select test_seq.nextval into :new.id from dual;
end test_trigger;
/
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
insert into UserInfo (name,age,sex,email,ads)values('张三',20,'男','e@e.com','地球') ;
select * from UserInfo ;
5/5 首页 上一页 3 4 5 |
