Re: DBA_ VIEWS Documentation
From: John Homeyard <homeyard_at_worldnet.att.net>
Date: 1996/08/20
Message-ID: <4vcvge$nse_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1
Date: 1996/08/20
Message-ID: <4vcvge$nse_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1
A couple of views are available for you to use.
The first is a view called dictionary which has 2 columns(table_name and comments). Try SELECT * FROM DICTIONARY;
The second is a view called dict_columns which explains what the columns of a specific view are all about.
F<adizon_at_mail.us.net> wrote:
>Where can I find a description of all the DBA_ Views? By description, I do
>not mean simply information as returned by the Describe command in
>SQLPlus. I also need a description of what each column is for.
>
>Thanks.
>
>Lito Dizon
>adizon_at_us.net
>
or instance a SELECT * FROM DICT_COLUMNS WHERE TABLE_NAME =
'DBA_VIEWS'; will provide you the information you seek.
John Received on Tue Aug 20 1996 - 00:00:00 CEST