有一张user表 字段 id,name
序列user_seq求一条语句,在.net中得到刚刚插入的序列值 insert into user(id,name)values(user_seq.nextval,'test')
.....
就像mssql中自增字段:
insert into user(name)values('test') select @@identity
序列user_seq求一条语句,在.net中得到刚刚插入的序列值 insert into user(id,name)values(user_seq.nextval,'test')
.....
就像mssql中自增字段:
insert into user(name)values('test') select @@identity
create table test(a int,b varchar2(100));
declare
v_a int;
v_b varchar2(100);
begin
insert into test
values
(seq_1.nextval, 'abc')
returning a, b into v_a,v_b;
dbms_output.put_line('a=' || v_a || ',' || 'b=' || v_b);
end;
/
--输出:a=1,b=abc
drop sequence seq_1;
drop table test;
select user_seq.nextval from dual;取序列的下一个值
select user_seq.curval from dual;取序列的当前值