SQL*Plus (MOSC)

MOSC Banner

DESC table with a large linesize

edited Sep 22, 2017 4:56AM in SQL*Plus (MOSC) 7 commentsAnswered ✓
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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center