SQL Plus - Describe

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

Describe lists the column definitions for a table, view, or synonym, or the specifications for a function or procedure.

Advertising

3 - Syntax

DESC[RIBE] {[schema.]object[@connect_identifier]}

where:

4 - 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)
lang/sqlplus/describe.txt · Last modified: 2017/09/06 19:29 by gerardnico