Re: Finding the definition of a view
From: Nils-Petter Tveranger <nils-petter.tveranger_at_ccmail.telemax.no>
Date: 1996/01/31
Message-ID: <310FAEEC.22F1_at_ccmail.telemax.no>#1/1
Date: 1996/01/31
Message-ID: <310FAEEC.22F1_at_ccmail.telemax.no>#1/1
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