Oracle list functions

-- 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');

Similar codes

2 votes403 views2 answers
Null column to 0 in mysql
SQL
3 votes295 views2 answers
Mysql sum with condition
SQL
0 vote376 views1 answer
Postgresql inheritance
SQL
0 vote288 views1 answer
Mysql select top 2
SQL
0 vote334 views1 answer
Oracle character index
SQL
1 vote347 views5 answers
Sql 2nd highest salary
SQL
1 vote326 views2 answers
Reset mysqli fetch_arra
SQL
3 votes324 views2 answers
Mysql add 2 hours
SQL
0 vote388 views1 answer
Insert value in identity
SQL
0 vote334 views1 answer
Mysql default uuid
SQL