Re: Get a list functions stored proc in sqlplus?

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