display a stored procedure

running oracle 8.1.7.2.  how can i display a stored procedure from the sqlplus command line?  i'm getting a bunch of junk on google and this is driving me nuts! thanks.

LVL 1
benpungAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
paquicubaConnect With a Mentor Commented:
To find the procedures:
SELECT OBJECT_NAME, OBJECT_TYPE FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE';
or
SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE';

to see the text:
SELECT TEXT FROM ALL_SOURCE WHERE NAME = < procedure name>;
or
SELECT TEXT FROM USER_SOURCE WHERE NAME = < procedure name>;


Hope this helps!
0
 
benpungAuthor Commented:
Thanks!
0
 
paquicubaCommented:
You're Welcome!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.