DESC table with a large linesize
Hi all,
i've little quesition. In my login.sql i set the the linesize to 3000, so i can prevent the wrapping of the resulting rows of the most queries.
But if i want to describe a table, i got this:
desc user_tables
Name
-----------------------------------------------------------------------------------------------------------------
TABLE_NAME
The width of the "Name" column is 1795 and i don't see the "Null?" and "Typ" without scrolling.
With a linesize of around 80 everything is fine:
< sys:op13@syse > set lin 80
< sys:op13@syse > desc user_tables
Name Null? Typ
----------------------------------------- -------- ----------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME VARCHAR2(30)
...
My workaround is a little script:
i've little quesition. In my login.sql i set the the linesize to 3000, so i can prevent the wrapping of the resulting rows of the most queries.
But if i want to describe a table, i got this:
desc user_tables
Name
-----------------------------------------------------------------------------------------------------------------
TABLE_NAME
The width of the "Name" column is 1795 and i don't see the "Null?" and "Typ" without scrolling.
With a linesize of around 80 everything is fine:
< sys:op13@syse > set lin 80
< sys:op13@syse > desc user_tables
Name Null? Typ
----------------------------------------- -------- ----------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME VARCHAR2(30)
...
My workaround is a little script:
0