Is there a setting to allow Oracle XE/SQLPlus to display more items before beginning a new header?

For example:

First Name           SURNAME              Subject                    MARK
-------------------- -------------------- -------------------- ----------
Rollo                Aslaug               Databases                    55
Rollo                Aslaug               Programming                  50
Rollo                Aslaug               Graphics                     65
Loki                 Laufeyson            Operating Systems            45
Loki                 Laufeyson            Programming                  40
Loki                 Laufeyson            Databases                    55
Ragna                Lothbrock            Databases                    80
Ragna                Lothbrock            Operating Systems            50
Ragna                Lothbrock            Programming                  65
Thor                 Odinson              Programming                  75
Thor                 Odinson              Graphics                     60

First Name           SURNAME              Subject                    MARK
-------------------- -------------------- -------------------- ----------
Thor                 Odinson              Databases                    60
Floki                Rafna                Databases                    75
Floki                Rafna                Operating Systems            45
Floki                Rafna                Graphics                     70

Is there a setting to remove the 2nd header in the middle of the query results?


In SQL*Plus, you can change the pagesize

SQL> set pagesize 100

will repeat the headings every 100 rows rather than every 15. You can set the pagesize value to (just about) whatever you'd like. If you want to ensure that the headers are only written once, you can set it to a number much greater than the number of rows that the query will return.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.