oracle分页查询：

SELECT
	*
FROM
	(
		SELECT
			ROWNUM AS rowno,t.*
		FROM
			tablename t
		WHERE
			hire_date BETWEEN TO_DATE ('20060501','yyyymmdd')
		AND TO_DATE ('20060731','yyyymmdd')
		AND ROWNUM <= 20
	) table_alias
WHERE
	table_alias.rowno >= 10;