Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Get a list functions stored proc in sqlplus?

Re: Get a list functions stored proc in sqlplus?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 4 Oct 2006 21:15:15 +0200
Message-ID: <45240843$0$5693$426a74cc@news.free.fr>

<cool.develop_at_gmail.com> a écrit dans le message de news: 1159987748.526333.226150_at_i42g2000cwa.googlegroups.com...
| 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.
|

USER_SOURCE? Regards
Michel Cadot Received on Wed Oct 04 2006 - 14:15:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US