Oracle XE/SQLPlus query display more items
In SQL*Plus, you can change the pagesize

SQL&gt; 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.