Re: Finding the definition of a view

Daniel Lieuwen wrote:
>
> Assuming one has DBA priveleges, how does one find the definition of a
> view? No one remembers the exact definition off hand, and we need it back.
>

Try the public view: all_views
SQL> desc all_views;

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 VIEW_NAME                       NOT NULL VARCHAR2(30)
 TEXT_LENGTH                              NUMBER
 TEXT                                     LONG

> Also, where can one find a complete list of system table (e.g. TABS, COLS)?
> Since they don't show up in TABS itself and I can't find even TABS and COLS
> in the indexes of any of the stack of about 10 books that came with the
> distribution, I'm out of ideas as to where to look.
>
> Thanks.
>
> Daniel

Try the query:
select owner, table_name
from
dba_tables
where owner = 'SYS'
or owner = 'SYSTEM';

Nils-Petter Received on Wed Jan 31 1996 - 00:00:00 CET