In the desc table of oracle, the name and type Columns cannot be formatted (The placeholder is too long)

In the desc table of oracle, the name and type Columns cannot be formatted. (The placeholder is too long.) oracle cannot format the oracledesc column name. The placeholder is too long. When we play Oracle today, in my desc table, I often find that the name and type columns occupy too many places and cannot intuitively display the values of each column, as shown in the following figure: This is very uncomfortable. Of course, when I see the column format problem, I first thought of formatting the column, So I entered

SQL> col name for a20;

 

But it didn't work, so I was very surprised. I thought about whether I set the value. Later I found that it was a problem with set linesize ..... Ah, if the linesize is too large, this problem will occur.

SQL> set linesize 100;

 

Solve the problem !!! As follows: