方法1 select object_id,object_name from (select object_id,object_name,row_number() over (order by object_id) r from t3) where r between 10 and 20;
OBJECT_ID OBJECT_NAM
--------- ----------
11 I_USER#
12 FET$
13 UET$
14 SEG$
15 UNDO$
16 TS$
17 FILE$
18 OBJ$
19 IND$
20 ICOL$
21 COL$
方法2: select * from (select * from (select object_id,object_name,rownum as rn from t3 order by object_id) where rn <10) where rn>1;
OBJECT_ID OBJECT_NAM RN
---------- ---------- ----------
3 I_OBJ# 6
15 UNDO$ 4
25 PROXY_ROLE 7
_DATA$
28 CON$ 3
29 C_COBJ# 5
39 I_IND1 8
44 I_USER1 2
51 I_CDEF2 9
上面的2个是有区别的,第一个是按照object_id顺序分页的,第二种的不是