Oracle: show all procedures in a database
-- 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%'; |
-- 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%'; |