create sequence s; insert into test values(s.nextval);
create table test(id number); create sequence s; insert into test values(s.nextval); insert into test values(s.nextval); insert into test values(s.nextval);select * from test; ID ---------- 1 2 3
insert into test values(s.nextval);
create table test(id number);
create sequence s;
insert into test values(s.nextval);
insert into test values(s.nextval);
insert into test values(s.nextval);select * from test;
ID
----------
1
2
3