Question

oracle 序列中升序和降序

Answer 1

INCREMENT BY参数可以实现
升序：
CREATE SEQUENCE customers_seq START WITH 1 INCREMENT BY 1;

降序：
CREATE SEQUENCE customers_seq START WITH 1000000000 INCREMENT BY -1;

Answer 2

举个例子吧
select * from emp t order by t.empno desc 降序
select * from emp t order by t.empno asc 升序