Re: Printing a data dictionary

From: <garethgadd_at_my-dejanews.com>
Date: Wed, 26 Aug 1998 12:06:14 GMT
Message-ID: <6s0tnm$urc$1@nnrp1.dejanews.com>

In article <6rru40$ltb$1_at_ns1.cat.com>,
  Pam Richmond <"Richmond_at_Pamela_D"@cat.com.NOSPAM> wrote:
> Does anyone know of a way in Oracle to print out a data dictionary
> (without
> doing a desc on each table)?
> Thanks!
>
>

Pam,

Try the following, I think it'll give you what you want

SQL> break on table_name
SQL> select table_name,

  2         column_name,
  3         data_type,
  4         data_length,
  5         decode(nullable,'N','NOT NULL',null)

  6 from all_tab_columns
  7 order by table_name;

If there is more information that you require then have a look at the ALL_TAB_COLUMNS view definition as it details column definitions etc

Regards

Gareth

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 07:06:14 CDT