Thanks guys. Haven't tried the suggestions, but I get the idea.
Brian Peasland wrote:
> cool.develop_at_gmail.com wrote:
> > Hi all:
> > Please somebody tell me how one goes about seeing the list of user
> > defined stored procedures or functions (say, current user's) while I am
> > in SQL Plus (8.1.7 environment)...and see the code?
> >
> > Unrelated note:
> > Googling, going through tutorials, oracle documentation (quick passes
> > only, alright...there are too many), browsing through sqlplus help did
> > not get me the answer to this trivia!! Either IT has grown too complex,
> > or they still haven't figured out how to write documentation. Or, I may
> > simply be growing too old after 10 years of IT consulting. Sucks. Truly
> > sucks. Or I may simply be having a bad day. I can't believe I can't
> > find the answer after spending so much time!! I could be doing
> > something more productive. I guess I should have thought about having a
> > dba pal.
> >
>
> All of the Data Dictionary views are documented here (for your version):
>
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/toc.htm
>
> The USER_OBJECTS view will show you all objects owned by the user you
> are connected with. The USER_SOURCE view will show you the source code
> of certain objects like procs, functions, and views.
>
> Replace "USER" with "ALL" to see all objects that you own *and* have
> access to. If you are signed on to the database with DBA privileges,
> then replace "USER" with "DBA" to see all objects in the database.
>
>
> HTH,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Wed Oct 04 2006 - 15:12:55 CDT
