8 thoughts on “set pages 50000

  1. Pingback: Laurent Schneider » Blog Archive » sql*plus pagesize explained

  2. Paulo Coelho

    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. Paulo Coelho

    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

Comments are closed.