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
SPOOL &1 ... SET PAGESIZE 0 PROMPT PROD|DIV|COMP|GEOG|CUSTOMER |CUR|YEAR|ACCOUNT|PER|VALUE SELECT /*+ index(GB,GL_BALANCES_N2) */ ...