Oracle show procedures

-- Depending on connected user grants:
SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
SELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');

Oracle show procedures

-- Specifically for SQL:Oracle

SELECT * 
FROM ALL_PROCEDURES;

Similar codes

0 vote142 views1 answer
Disableforiegn key check
SQL
3 votes138 views1 answer
Oracle undo tablespace list by user
SQL
4 votes150 views2 answers
Bulk kill mysql processlist
SQL
1 vote146 views2 answers
How to search date in sql query
SQL
0 vote134 views1 answer
Mysql export and import
SQL
0 vote142 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote141 views1 answer
Postgres statistics
SQL
1 vote154 views1 answer
Mysql select and count left join
SQL
0 vote143 views1 answer
Stored function in sql
SQL
0 vote137 views1 answer
Mysql count grouped rows
SQL