Wednesday, May 3, 2017

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"



0 comments:

Post a Comment

Contact

Get in touch with me


Adress/Street

Bangalore, India