DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL*plus 8.1.6 buggy?

  1. 11-01-2001, 01:08 PM #1
    rexbone
    rexbone is offline Junior Member
    Join Date
    Mar 2001
    Posts
    24
    I find that when I do a select on tables in sql*plus some of the output widthwise is chopped off regardless of linesize setting. Is there a patch I can apply to my 8.1.6 home installation?

    Thanks
    Rex
    Reply With Quote Reply With Quote
  2. 11-01-2001, 06:33 PM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Is it possible that those columns that are copped off are of type LONG? You must explicitely set the number of characters that gets displayed for LONGs in SQL*Plus with SET LONG settings, no matter of how you set your LINESIZE.

    SET LONG = 1000000 will alow you to display 10**6 characters of your LONG columns, for example. The default for LONG in SQL*Plus is 80 characters, I belive.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  3. 11-02-2001, 05:33 AM #3
    rexbone
    rexbone is offline Junior Member
    Join Date
    Mar 2001
    Posts
    24

    Still bugs bunny

    Should have mentioned that truncation occurrs when using desc. Might upgrade my sql*plus to 8.1.7 or even downgrade to a version I know works!

    Thanks anyway
    Rex
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width