Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007

    Red face Unanswered: Page formatting in PL/SQL or SQL

    Trying to set the page size and linesize in a query.
    Using Oracle 10g
    At the SQL prompt I typed help index and saw 2 commands that might work but unable to successfully make that happen.
    I have used SQLPlus extensively and it has a function called pagesize linesize but this version of Oracle will not let me use it.
    Sorry for the long text.
    The query returns data too large for the default linesize and I get wrapping.

    The 2nd part is I am using a decode function that the string is too large for the line, etc.

    It goes like this
    Select patid,key
    from name of database table
    where tag in(34,158)
    group by patid,key
    tried adding the substr in the decode clause and got an error unknown command

    As you can tell failrly new at this.
    Plz, any assistance would be appreciated

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    > but this version of Oracle will not let me use it.
    Please use CUT & PASTE to allow us to see exactly what you are doing & how Oracle responds.

    I assume that the length of the returned line is longer than the width of your terminal window; which gives the APPEARANCE of line wrapping.

    I can assure
    works as documented.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2007

    Red face

    Will have to wait till Monday. This happens on my work computer.
    Thanks for the quick reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts