Oracle Querys List Store Procedures

Oracle List Procedure.sql

-- List all 

SELECT * FROM User_Procedures;
  
SELECT * FROM DBA_Procedures;

-- Find procedure and source

SELECT * FROM DBA_Procedures WHERE PROCEDURE_NAME = 'PROCEDURE_NAME';
 
SELECT * FROM User_Source WHERE name = 'PROCEDURE_NAME' ;
 
SELECT * FROM DBA_Source WHERE name = 'PROCEDURE_NAME';