Re: Finding the definition of a view
Date: 1996/01/30
Message-ID: <4ejojm$it6_at_gossamer.itmel.bhp.com.au>#1/1
In article <4ej7da$sm7_at_big.info.att.com>, Daniel Lieuwen <lieuwen> says:
>
>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.
>
>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
>
Daniel,
Try dumping table ALL_VIEWS. This should show all views to which you
have access.
DBA_VIEWS might be more useful.
Consider buying the SQL Language Quick Reference - Part No 5421-70-1292
This is a really useful little book which includes syntax for
commands and a list of all the DBA tables, as well as the dynamic
performance table names, and a description of each
HIH
Lee
------/\/\------+---------------------------------------------------
/ / /\ | Lee Levy, ISSD Systems Development, Del Code (34)
/ / / \ | BHP Information Technology, ACN 006 476 213
/ / / /\ \ | PO Box 261, Warrawong, NSW 2502, Australia
\ \/ / / / | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-
\ / / / | Internet : levy.lee.ls_at_bhp.com.au
-----\/\/\/-----+---------------------------------------------------Opinions expressed are mostly my own, so give me some credit. Received on Tue Jan 30 1996 - 00:00:00 CET