Q
Problem solve Get help with specific problems with your technologies, process and projects.

Command to view stored procedure

Which command is used to view a stored procedure?

How to view a stored procedure? Which command is used to view a stored procedure?

You can use the following data dictionary views to display the body from stored procedures:

    user_source
    dba_source
    all_source

I have listed an example of how to use the user_source view:

SELECT TEXT from user_source
where type='PROCEDURE'
AND NAME = 'PROC1'
ORDER BY LINE

Where TEXT lists the body of procedure "PROC1."

Dig Deeper on Using Oracle PL-SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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