You are now on my old blog. Please update your bookmarks to my new blog
http://laurentschneider.com




16 June 2005

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

0 Comments:

Post a Comment

<< Home