How to see code of a stored Procedure in PL/SQL

Question

I have made multiple procedures in pl/sql oracle, using APEX.

I want to see pl/sql code for my Procedures.

I need a query to do this operation, not through wizards and stuff.

Kindly help me?

Answer 1

Well I found the solution. Very simple.

SELECT TEXT 
FROM USER_SOURCE 
WHERE NAME = 'PROCEDURE NAME';

Note that procedure name must be in capitals.

For example:

SELECT TEXT 
FROM USER_SOURCE 
WHERE NAME = 'SELECTION_SORT';