Dispaly LONG column in SQL*PLUS ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dispaly LONG column in SQL*PLUS ?

  1. #1
    Join Date
    Jun 2001
    Posts
    103
    Hi all.

    How i can display long column correctly(All content) in SQL*PLUS.
    for example :
    SQL> select trigger_name,trigger_body from user_triggers where trigger_name='MYTRIGGER';
    Which setting in SQL*PLUS needed?

    Sorry for my english!!!
    Best Regards.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Use

    SET LONG 1000

    which will allow you to get first 1000 characters of long column. Use whatever value suits your needs. I belive the default setting is 80.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jun 2001
    Posts
    103
    Hello modic.
    Thank you for 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
  •  



Click Here to Expand Forum to Full Width