Oracle序列

 

 mysql与Oracle的SQL对比

create table test1111(
   id number(10) primary key,
   username varchar2(100)
);
create sequence myseq;

select myseq.nextval from dual
select myseq.currval from dual

select * from test1111;

insert into test1111(id,username) values(myseq.nextval,'小明');
insert into test1111(id,username) values(myseq.nextval,'小芳');
commit;


select * from test1111;