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 vote166 views2 answers
What is rownum in oracle
SQL
1 vote150 views2 answers
Extract weekday from date in sql
SQL
9 votes193 views1 answer
No sql
SQL
0 vote146 views1 answer
Jenkins SQLCMD run
SQL
2 votes155 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
4 votes176 views1 answer
Ms sql truncate table vs delete
SQL
2 votes157 views2 answers
Mysql alter column default
SQL
0 vote182 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote145 views1 answer
Too many connections mysql
SQL
0 vote141 views1 answer
Mysql export and import
SQL