第1个回答 2011-09-26
没看见采纳啊,晕了,这样麻烦的话,用oracle自带的吧,
create sequence seq;
create table person(id number(3),name varchar2(10));
insert into person values (seq.nextval,“测试1”);
insert into person values (seq.nextval,“测试2”);
insert into person values (seq.nextval,“测试3”);
select * from person;
id:结果 1 2 3