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 vote283 views1 answer
Delete duplicate rows
SQL
15 votes365 views5 answers
Select all tables sql
SQL
3 votes245 views3 answers
Mysqldump: couldn
SQL
0 vote277 views1 answer
Automated psql csv export script on windows
SQL
3 votes280 views1 answer
Get current month last date in sql server
SQL
1 vote289 views1 answer
Sql set auto increment back to 0
SQL
0 vote243 views1 answer
Oracle index hint multiple tables example
SQL
0 vote293 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote252 views2 answers
Postgresql get long running queries
SQL
0 vote274 views1 answer
Select * where id = 1,2,3
SQL