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."