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 vote222 views1 answer
Sql get latest of 2 datetimes
SQL
12 votes204 views4 answers
Psql command not found
SQL
0 vote433 views1 answer
Power bi connect to postgresql
SQL
0 vote196 views1 answer
Mssql disable foreign key constraint
SQL
0 vote186 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
1 vote272 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
1 vote240 views1 answer
Sql in array query
SQL
0 vote190 views1 answer
Heavy table in mysql
SQL
0 vote197 views1 answer
Look at running processes redshift
SQL
0 vote255 views1 answer
Postgresql conectar
SQL