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
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
Pingback: Laurent Schneider » Blog Archive » sql*plus pagesize explained
This is really helpful.
I have one more problem.
How to remove dotted lines like “——-” after heading?
U can contact me on “[email protected]”
set und off
Hi, nice tip, hope you can help with that one: I must generate a flat file with over 100 thousand lines and with one heading.
If I set pagesize to 0, I get no heading at all. If I set pagesize to 50000, I get more than one heading.
I´ve tried several combinations but none worked!
Regards, Paulo
did you try set emb on pages 0 newp none hea on ?
(newp 0 also works Oracle7, but I prefer newp none thoses days.
Tks, it would be perfect if I weren´t using TTITLE, because my select is like that: field1||’;’||field2 etc. So, I had to set head off.
Regards, Paulo
That’s a very helpfull trick, thanks a lot!
Thanks