About
Describe lists the column definitions for a table, view, or synonym, or the specifications for a function or procedure.
Articles Related
Syntax
DESC[RIBE] {[schema.]object[@connect_identifier]}
where:
- connect_identifier is a database link - connect identifier
Formatting
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)