14:36:47 SQL> select x.owner,x.object_name,x.object_id,x.status from (select rownum rn,a.* from test a) x where x.rn between 1 and 20;
Elapsed: 00:00:00.01

Execution Plan
----------------------------------------------------------
Plan hash value: 1984214786

----------------------------------------------------------------------------
| Id | Operation           | Name | Rows | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------
|   0 | SELECT STATEMENT    |      | 1607K|   174M| 4992   (3)| 00:01:00 |
|* 1 | VIEW               |      | 1607K|   174M| 4992   (3)| 00:01:00 |
|   2 |   COUNT             |      |       |       |            |          |
|   3 |    TABLE ACCESS FULL| TEST | 1607K|    64M| 4992   (3)| 00:01:00 |
----------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

1 - filter("X"."RN"<=20 AND "X"."RN">=1)

Select
Tname,
Tabtype
FROM
(Select
    Tname,
    Tabtype,
    Rownum Rn
FROM
    (SELECT * FROM Tab ORDER BY Tname
    )
WHERE rownum <=150
)
WHERE rn>=100;

ITPub博客

oracle sql分页查询（一）

最新文章