You are now on my old blog. Please update your bookmarks to my new blog

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


Post a Comment

<< Home