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

8 thoughts on “set pages 50000”

  1. 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”

  2. 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

  3. 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

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>