sql for listing stored procedure in oracle database code example

Example: oracle show procedures

-- Specifically for SQL:Oracle

SELECT * 
FROM ALL_PROCEDURES;