Re: Printing a data dictionary

From: <garethgadd_at_my-dejanews.com>
Date: Wed, 26 Aug 1998 11:53:58 GMT
Message-ID: <6s0t0m$u2u$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!
>
>

Try the following - it should give yo9u what you want :

SQL> break on table_name
SQL> l
  1 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

-----== 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 - 06:53:58 CDT