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

17 votes306 views6 answers
Get last record in sql
SQL
0 vote305 views2 answers
Sql join on comma separated field
SQL
2 votes298 views1 answer
Check isolation level in mysql
SQL
0 vote314 views1 answer
Sql pad left 0
SQL
0 vote298 views1 answer
Mysql count by month
SQL
0 vote306 views1 answer
Mariadb hours between two dates
SQL
0 vote308 views1 answer
How many rows affected in sqllite
SQL
0 vote316 views1 answer
How to to get time in sql
SQL
0 vote316 views1 answer
Mysql change innodb to myisam
SQL
0 vote248 views1 answer
Oracle sql replace string in clob
SQL