This content has been marked as final. Show 3 replies
Ranzalman wrote:Apparantly, 50,000 lines is the max. If you try to set PEGESIZE higher than that, you get the default, which is 14.
Hi I am running a simple SQL query in SQLPLUS, and I want the column headers to appear just once at the top.
If I set the 'SET PAGESIZE' to 50000 (which I thought was the max) it repeats the column headers evert 50000 lines.
If I set 'SET PAGESIZE 50001', the column header appears every 14 lines
The best thing might be to SET PAGESIZE 0, which turns off paging. Unfortunately, that turns off the automatic headers, too, so you'll have to supply your own header, manually, like this:
SPOOL &1 ... SET PAGESIZE 0 PROMPT PROD|DIV|COMP|GEOG|CUSTOMER |CUR|YEAR|ACCOUNT|PER|VALUE SELECT /*+ index(GB,GL_BALANCES_N2) */ ...