Re: Data Dictionary

From: Fred A G <nospam_at_allowed.localhost>
Date: Thu, 1 Mar 2001 23:52:38 +0100
Message-ID: <hnAn6.5586$hi2.16157@nntpserver.swip.net>

"Nick G. Anagnos" <anagnon_at_westat.com> wrote in message news:3A9EB012.AFB448A3_at_westat.com...
> Was wondering if anyone knows of a site where I can download a
listing
> of all_* , dba_*, and user_* data dictionary views. Interested
in
> the view stucture and column meanings.
>
> Nick G. Anagnos
>

At least to start with, you could ask the dictionary about it (is that meta-meta-data? ;-)).

select ... from dict where table_name like 'DICT%' ;

And use DESCRIBE to describe tables also.

Hth
/Fad Received on Thu Mar 01 2001 - 16:52:38 CST