Question

oracle已建了序列，再怎么按升序处理

create sequence dtseq_id
minvalue 0
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
select dtseq_id.nextval dtseq_id,a01,b01 from table;
drop sequence dtseq_id;
想按a01升序排列
这里怎么处理
谢谢各位大神

Answer 1

select dtseq_id,a01,b01 from table order by a01;