Describe lists the column definitions for a table, view, or synonym, or the specifications for a function or procedure.
DESC[RIBE] {[schema.]object[@connect_identifier]}
where:
You cannot define a formatting by column. Describe takes only the parameter linesize into account.
Example“
>desc my_emp
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
EMPNO NUMBER
LAST_NAME VARCHAR2(30)
START_TIME TIMESTAMP(6)
END_TIME TIMESTAMP(6)
>set linesize 50
>desc my_emp
Name Null? Type
----------------------- -------- ----------------
EMPNO NUMBER
LAST_NAME VARCHAR2(30)
START_TIME TIMESTAMP(6)
END_TIME TIMESTAMP(6)