Re: Table documentation

Hi,

I'll give the basic idea.

In SQL*PLUS:

SQL> set linesize 120
SQL> set pagesize 5000
SQL> desc user_tab_columns
 Name                            Null?    Type
 ------------------------------- -------- ----
 TABLE_NAME                      NOT NULL VARCHAR2(30)
 COLUMN_NAME                     NOT NULL VARCHAR2(30)
 DATA_TYPE                                VARCHAR2(9)
 DATA_LENGTH                     NOT NULL NUMBER
 DATA_PRECISION                           NUMBER
 DATA_SCALE                               NUMBER
 NULLABLE                                 VARCHAR2(1)
 COLUMN_ID                       NOT NULL NUMBER
 DEFAULT_LENGTH                           NUMBER
 DATA_DEFAULT                             LONG
 NUM_DISTINCT                             NUMBER
 LOW_VALUE                                RAW(32)
 HIGH_VALUE                               RAW(32)
 DENSITY                                  NUMBER
 NUM_NULLS                                NUMBER
 NUM_BUCKETS                              NUMBER
 LAST_ANALYZED                            DATE
 SAMPLE_SIZE                              NUMBER

SQL> break on table_name
SQL> SELECT table_name, column_name, data_type, data_length   2 FROM user_tab_columns
  3 ORDER BY table_name, column_name   4 /

TABLE_NAME                     COLUMN_NAME                    DATA_TYPE

------------------------------ ------------------------------ ---------
-----------
BONUS                       COMM
NUMBER             22
                               ENAME
VARCHAR2           10
                               JOB
VARCHAR2            9
                               SAL
NUMBER             22
DEPT                           DEPTNO
NUMBER             22
                               DNAME
VARCHAR2           14
                               LOC
VARCHAR2           13
EMP                            COMM
NUMBER             22
                               DEPTNO
NUMBER             22
                               EMPNO
NUMBER             22
                               ENAME
VARCHAR2           10
                               HIREDATE
DATE                7
                               JOB
VARCHAR2            9
                               MGR
NUMBER             22
                               SAL
NUMBER             22
SALGRADE                       GRADE
NUMBER             22
                               HISAL
NUMBER             22
                               LOSAL
NUMBER             22

18 rows selected.

SQL> Regards

Hakan

Corinna Becker wrote:

> Hello,
> I want to write a documentation of all our tables by using the desc
> command.
> Is there a way to do something in SQLPLUS like "desc (all tables that we
> have)"?
> Thanks in advance
> Corinna Becker
Received on Tue Aug 11 1998 - 14:24:25 CDT