Re: Cracking open a view

Now it's time to start reading some of the Oracle documentation. Oracle has three sets of views i.e. user_objects, all_objects, dba_objects. Read about the differences. The pipe symbols just mean to choose one of the three in this case.

Van

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tgf8e7iuoo8sc6_at_beta-news.demon.nl...
>
> "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 - 18:34:00 CDT