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 vote386 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
9 votes348 views2 answers
Sql limit to 5 results
SQL
7 votes370 views4 answers
Index in mysql
SQL
0 vote323 views1 answer
Increment id in mysql
SQL
0 vote327 views1 answer
Sum sqlserver
SQL
0 vote364 views1 answer
Alter table change default
SQL
2 votes354 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
3 votes335 views1 answer
Oracle revoke
SQL
0 vote342 views1 answer
Mysql DDL
SQL
1 vote345 views1 answer
Top 10 rows in mysql
SQL