Re: INFORMATION_SCHEMA

On Sun, 14 May 2006 10:32:32 +0200, "astalavista" <nobody_at_nowhere.com> wrote:

>Hi,
>
>INFOMATION_SCHEMA seems to standrd to access dictionnary tables
>on many RDBMS.
>Do you know if it is available in Oracle ?
>I tried it but no success...
>
>Thanks in advance ...
>

There is not. The dictionary consists of a series of views in the SYS schema, on tables in the SYS schema, accessible to everyone. Generally there are 3 levels
DBA_ : all objects in the database
ALL_ : all objects accessible to you
USER_ : your own

Select * from dict
tells you which views there in the dictionary.

Of course this is documented.

--
Sybrand Bakker, Senior Oracle DBA