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
    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
    Ljubljana, Slovenia

    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
    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