--创建sequence
create
sequence
seq_on_test
increment
by
1
start
with
1
nomaxvalue
nocycle
nocache;
--建表
drop
table
test;
create
table
test(
ID
integer
,stu_name nvarchar2(4)
,stu_age number
);
--插入数据
insert
into
test
values
(seq_on_test.nextval,
'张三'
,24);
insert
into
test
values
(seq_on_test.nextval,
'李四'
,25);
select
*
from
test;
--结果
/*
1 张三 24
2 李四 25
*/
--seq的两个方法
select
seq_on_test.currval
from
dual;
select
seq_on_test.nextval
from
dual;
--结果
/*
2
3
*/