Q
Manage Learn to apply best practices and optimize your operations.

How to view a list of stored procedures through SQL*Plus?

How can I get a list of stored procedure objects from SQL*Plus? How can I view the source of the stored procedures?

How can I get a list of stored procedure objects from SQL*Plus? How can I view the source of the stored procedures using SQL*Plus?
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.

Dig Deeper on Oracle and SQL

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close