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

6 votes211 views2 answers
Insert into select mysql
SQL
0 vote210 views1 answer
Default value false mysql
SQL
13 votes202 views2 answers
Display users in mysql
SQL
5 votes246 views1 answer
Oracle get ddl
SQL
0 vote215 views1 answer
Sql trying to delete database in use
SQL
0 vote210 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote224 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
8 votes213 views3 answers
Postgresql connection string c#
SQL
0 vote219 views1 answer
Sql period overlap
SQL
1 vote211 views1 answer
Postgresql datetrunc too slow
SQL