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

    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
    max(decode(tag,34,data,''))Which_Referral,
    max(decode(tag,158,data,''))Nutri_Cmt
    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
    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    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
    SQL> SET LINESIZE 131
    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
    Posts
    2

    Red face

    Ok,
    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
  •