-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|