Command to view stored procedure

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

    user_source

    dba_source

    all_source

Here is 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"

If you think our posts are helpful, then do not forget to share our posts with your friends because your support makes better future. Register here for more updates ☆

Learn ~ Share ~ Grow ☺ Thanks & Happy Reading ✍