Re: Cracking open a view

Van Messner wrote:

> 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
> >
> >
> >
> >

To Van and Sybrand-
 I am now up to speed on that syntax and have been churning my way through views as a result of your very helpful replies. I guess with a simple query like this at one's disposal, why would anyone fool around with Schema Manager or TOAD? I know full well there are lots of other things you can do with those utilities but it is great to have this capability right from within my instance here. Thanks again for the help.

Joel A. Stevens Received on Sun May 20 2001 - 22:36:12 CDT