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..
Forum Rules
Bookmarks