By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,262 Members | 1,125 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,262 IT Pros & Developers. It's quick & easy.

SQLPlus SELECT Headers

P: 22
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
Jan 24 '08 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
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
Jan 25 '08 #2

P: 22
ah, thanks so much :)
Jan 25 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.