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 vote228 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote206 views2 answers
Create sequence if not exists postgres
SQL
1 vote212 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote263 views1 answer
Isnull in sqlite
SQL
1 vote282 views1 answer
Connect to mysql database ubuntu
SQL
0 vote227 views1 answer
How to change the field size of an existing column
SQL
0 vote159 views1 answer
Plsql trigger insert update
SQL
5 votes214 views1 answer
Sql integer to serial
SQL
1 vote227 views1 answer
Sql group by sum with condition
SQL
0 vote232 views1 answer
Stratified sampling sql
SQL