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 vote267 views1 answer
Drop database using terminal postgres
SQL
1 vote256 views1 answer
Find difference in dates sql
SQL
0 vote244 views1 answer
How to print out column name differently in mysql
SQL
3 votes253 views2 answers
Postgresql remove not null constraint
SQL
1 vote263 views1 answer
SQL: merging multiple row data in string
SQL
0 vote246 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
1 vote257 views1 answer
Copy postgres table from one schema into another
SQL
0 vote206 views1 answer
Finish transaction sql
SQL
0 vote217 views1 answer
Deleted table in sql trigger
SQL
0 vote241 views2 answers
Drop check constraint in ms sql
SQL