How do I set WORD_WRAPPED for ALL columns???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How do I set WORD_WRAPPED for ALL columns???

  1. #1
    Join Date
    Mar 2001
    Posts
    286

    Question

    In SQL Plus, I know I can wrap words of a wide column by using
    "column column_name WRAPPED WORD_WRAPPED"

    How do I set WORD_WRAPPED for ALL columns???

    SQL> desc V$FIXED_VIEW_DEFINITION
    Name Null? Type
    ----------------------------- -------- --------------------
    VIEW_NAME VARCHAR2(30)
    VIEW_DEFINITION VARCHAR2(4000)

    SQL> column VIEW_DEFINITION WRAPPED WORD_WRAPPED
    SQL> column VIEW_DEFINITION format a70




  2. #2
    Join Date
    Feb 2001
    Posts
    184
    If You Know the Column names then you can have them in your Login File and whenever they appear in SQL, will be wrapped.
    Other way to have a script that contains all those columns to be wrapped, run as soon as you login Oracle throgh SQL Plus, ...

    Hope this works.

    Thanks..

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