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 vote327 views2 answers
Restart identity cascade
SQL
0 vote327 views1 answer
Mysql docker image arjun
SQL
1 vote355 views3 answers
Postgresql get difference between two dates
SQL
3 votes332 views1 answer
Sql server version query
SQL
0 vote337 views1 answer
Query params sql insert python f string
SQL
37 votes518 views3 answers
Sql check duplicate value in column
SQL
2 votes322 views1 answer
Oracle trace session
SQL
0 vote327 views1 answer
Sql server bool select
SQL
-1 vote336 views1 answer
Mysql select all columns and specific fields as
SQL
6 votes333 views2 answers
Clear a table in mysql
SQL