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

0 vote190 views1 answer
Login failed for login due to trigger execution
SQL
1 vote188 views1 answer
Delete row mssql
SQL
0 vote191 views1 answer
Mysql sql.gz
SQL
16 votes213 views2 answers
Sql exists
SQL
0 vote253 views1 answer
Postgres rename database
SQL
5 votes200 views4 answers
Upload database mysql command line
SQL
3 votes194 views1 answer
Oracle apex call duration
SQL
2 votes188 views1 answer
Oracle table size
SQL
0 vote235 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote193 views1 answer
Postgres concat_ws
SQL