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 vote125 views1 answer
WHERE not regex in SQL
SQL
2 votes126 views2 answers
Python escape string for sql
SQL
13 votes120 views2 answers
Get tables in database sql
SQL
1 vote126 views1 answer
Oracle activate job
SQL
1 vote132 views1 answer
Sql select row with max date
SQL
1 vote114 views1 answer
Join first name and last name sql
SQL
0 vote115 views1 answer
How to check replication lag in mySQL
SQL
5 votes126 views1 answer
Find table from column name in sql
SQL
0 vote111 views1 answer
Time mysql w3
SQL
0 vote130 views1 answer
Postrgesql concat 2 columns divided by ;
SQL