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

1 vote333 views1 answer
Sql week commencing date
SQL
0 vote342 views1 answer
Oracle right characters
SQL
4 votes358 views3 answers
Copy table postgres
SQL
3 votes338 views1 answer
Oracle wait
SQL
0 vote357 views2 answers
Android sqlite query join
SQL
1 vote307 views1 answer
Strict in postgres SQL
SQL
2 votes367 views1 answer
How to delete all duplicate items in mysql
SQL
5 votes383 views3 answers
Postgres show databases
SQL
0 vote329 views1 answer
Strat with in sql
SQL
0 vote349 views1 answer
Hibernate xml property MySQL url, username and password
SQL