1.在你的表里创建序列
create sequence table.columnid
minvalue 1
maxvalue 99999999999999999999999
start with 1
increment by 1
cache 5;2.插入的时候使用序列的自动增加数columnid.nextval
insert into table (....)
values(columnid.nextval,.....)
create sequence table.columnid
minvalue 1
maxvalue 99999999999999999999999
start with 1
increment by 1
cache 5;2.插入的时候使用序列的自动增加数columnid.nextval
insert into table (....)
values(columnid.nextval,.....)
select ...,you_id from tablename where ...... order by you_id asc/desc;