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

1 vote227 views1 answer
Ilike for date postgres
SQL
3 votes246 views1 answer
Postgresql today - 1 year
SQL
17 votes276 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote220 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote242 views1 answer
Sql dmv to capture updates
SQL
0 vote245 views1 answer
Sql delete from with relation
SQL
13 votes229 views2 answers
Sql join
SQL
0 vote244 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote229 views1 answer
No suitable driver found for sqlite
SQL
0 vote229 views1 answer
Alasql delete column
SQL