Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Get a list functions stored proc in sqlplus?
<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