Re: Cracking open a view

"Joel A. Stevens" <joelst_at_nsis.net> wrote in message news:3B07331A.EA52D566_at_nsis.net...

Sybrand Bakker wrote:
"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
Hello Sybrand-
I want to thank you very much for a very prompt and helpful reply. I am able to get my text for the views now and I do greatly appreciate it. Just for the record, your syntax indicates "user|all|dba_views". Initially, I tried this by using "...from user|all|dba_views.." but got an error message. What worked was simply ... from dba_views.. I was unsure what you meant with the syntax using the pipe characters. Thank you.
Joel A. Stevens

Common lingo for dba_views OR all_views OR user_views, as from your post I can't know how you are accessing the database. You are aware what those three levels mean hopefully?

Regards,

Sybrand Bakker, Oracle DBA Received on Sun May 20 2001 - 05:53:55 CDT