-- list all procedures
SELECT * FROM ALL_PROCEDURES;
 
-- search for a procedure with "test" inside the name
SELECT * FROM ALL_PROCEDURES WHERE UPPER(procedure_name) LIKE '%TEST%';