Displaying output in SQLPlus I will open my SQLPlus with CMD in windows. When I write a query it shows 157998 rows as result. I want see the all result in sqlpus window, but it is not showing all the result.
Not an Oracle/SQL*Plus problem. The default size of commandline window screen buffer is 300 (lines), and the maximum is 9999 (lines), so it is unable to display 157998 rows.

Better spool the output to a file:

SQL&gt; spool output.txt
SQL&gt; select ...
SQL&gt; spool off


After that you can view the result in the file output.txt