I have often see set pagesize 50000 or set pages 9999, just to avoid page break.
I wonder how many line break will appears when the select grow over 50000…
A cool solution is to use embedded with pagesize 0
SQL> set emb on pages 0 newp 0
This entry was posted
on Thursday, June 16th, 2005 at 16:36 and is filed under oracle, sqlplus.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Post to :
del.icio.us
- Digg it
- Furl
- reddit
- Spurl
June 4th, 2007 at 15:40
[…] This is rather an annoying effect of the default setting than a feature and there is no set pagesize unlimited. The only way to have the header only once, is to set the pagesize to the maximum or use this trick : set pages 0 emb on newp none. Unfortunately, the later does not work for HTML reporting. […]
March 12th, 2008 at 17:35
This is really helpful.
I have one more problem.
How to remove dotted lines like “——-” after heading?
U can contact me on “arpitshah4u@gmail.com”
March 12th, 2008 at 18:10
set und off