小茗的专栏

 SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME ORDER BY ID) A WHERE ROWNUM )WHERE RN >= 21其中最内层的查询SELECT * FROM TABLE_NAME表示不进行翻页的原始查询语句。ROWNUM = 21控制分页查询的每页的范围。上面给出的这个分页查询语句

--创建序列create sequence SEQ_Table_ID;  --创建行级触发器create or replace trigger TableName_BIR  before insert on TableNamefor each Rowbegin  select SEQ_Table_ID.nextval into :new.Id from dual;end TableName_BI