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 vote318 views1 answer
SQL date part only of datetime
SQL
0 vote334 views1 answer
How to list function in psql
SQL
0 vote333 views1 answer
Mysql multiple group by
SQL
1 vote307 views1 answer
What is intersect
SQL
5 votes354 views1 answer
Get column name sql server
SQL
0 vote317 views1 answer
How to select only id where is not in column mysql
SQL
0 vote328 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote317 views2 answers
How to search date in sql query
SQL
3 votes284 views1 answer
Get all elements sql
SQL
0 vote326 views1 answer
Sqlite löschen einer tabelle
SQL