Set Heading Offset Feedback Offset PageSize 2000
SELECT TFROM (SELECT T, ROWNUM ROWCOUNT from T) Torder by RowCount DESC;
Set Heading Onset Feedback on
SQL> SELECT T 2 from (SELECT T, ROWNUM ROWCOUNT from T) T 3 Order by RowCount DESC;
T --------------------------------------------------- ------------------------------ ((`'-" `` "" -' `)) - - ( / (O _ o) / / / (0) / _ '-.._' = '_..-'_ /`;#'#'# ``/ / _)) '#' ((_ / #. ☆ ☆ ☆ # '#. Thank you! #' / '#.. #' / _ / / '#.. #' / / _ (((___) '#' (___)
12 rows success
SQL>