Re: Cracking open a view

"Joel Stevens" <joelst_at_nsis.net> wrote in message news:418cefb1.0105191349.572b535a_at_posting.google.com...
> I am getting underway with Oracle and have access to a
> database that is pretty representative of a production
> environment. I am aware there is an Oracle tool that
> allows me to "crack" open or break down an existing View
> so that I can see which fields from specific tables
> are used to make up the View. I believe it is a tool
> that can be purchased from Oracle and is maybe part of
> a larger package called something like Oracle Development
> Manager or Oracle Scheme Manager. I would appreciate if
> someone could provide the name of this tool. Thanks.

You won't need a tool for that.
You just need to realize a view is defined in the datadictionary, and you can get the definition from the datadictionary. Just
set long 10000
select text
from user|all|dba_views
where view_name = '<your view name>'

Agreed, if you do want a GUI interface, and you don't want to study the datadictionary, you can either get Oracle Enterprise Manager (which includes Oracle Schema Manager), or TOAD (Tool for Oracle Developers, foc version at www.toadsoft.com )

Regards,

Sybrand Bakker, Oracle DBA Received on Sat May 19 2001 - 17:44:34 CDT