paging of system tables in Oracle v12 Database

pagingsystables.sql

WITH f
	 AS (SELECT object_name,
				created,
				ROWNUM rn,
				COUNT (*) OVER (PARTITION BY NULL) cnt
		   FROM (SELECT object_name, created
				   FROM user_objects
				  WHERE ROWNUM < 17 --some kind of restriction 
				 ORDER BY object_name))
SELECT f.*,
	   CEIL (cnt / 4),
	   CASE
		   WHEN rn <= CEIL (cnt / 4) THEN 1
		   WHEN rn BETWEEN CEIL (cnt / 4) AND CEIL (cnt / 4) * 2 THEN 2
		   WHEN rn BETWEEN CEIL (cnt / 4) * 2 AND CEIL (cnt / 4) * 3 THEN 3
		   ELSE 4
	   END
		   filtro
  FROM f
ORDER BY object_name, filtro;