SQLPlus SELECT Headers

[andrewteg]

I am spooling some output using sqlplus command line tool and after about 10-15 rows it repeats the header (field names) in my testing. I was wondering if there was a way to suppress it from repeating the field names so I could get a more table-like output without having to delete the extra rows of field names thrown in.

Thanks for any input,
Andrew

[debasisdas]

By default in sqlplus the page size is 14 . You need to increase the value to avoid repeating the headers . Max pagesize can be 50000.

use this to set the pagesize

set pagesize 200

[andrewteg]

ah, thanks so much :)