set pages 50000
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 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
0 Comments:
Post a Comment
<< Home