View List of stored procedures through SQL*Plus?

I was trying and googling to list all the stored procedures in the database. I couldn't get that information easily. Finally i  got it. I thought i can share this with you all so that others can find easily. The DBA_PROCEDURES view will show all stored procedures in the database. The USER_PROCEDURES view will show the stored procedures that your current user owns. Once you know the stored procedures, you can view the source code in either DBA_SOURCE or USER_SOURCE.  Hope this might help the others.

Tags: database, stored procedure, user_source, dba_source, current user, oracle, sql plus

Can't find what you're looking for? Try Google Search!

	Web eshwar123.blogspot.com