下面是Oracle中使用分页查询的示例代码:
SELECT *
FROM (SELECT ROWNUM rn, t.*
FROM (SELECT *
FROM table_name
ORDER BY column1) t
WHERE ROWNUM <= page_size * page_number)
WHERE rn > page_size * (page_number - 1);
在上面的代码中, table_name
是需要查询的表的名称,column1
是需要排序的列,`page_size