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 vote268 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote309 views1 answer
Database schema for mcqs type exam in sql
SQL
-1 vote285 views1 answer
Spring boot mysql connection properties
SQL
0 vote281 views1 answer
Sql count null values in all columns
SQL
0 vote271 views1 answer
Drop specific row postgresql
SQL
0 vote273 views2 answers
SQL FROM
SQL
0 vote284 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote260 views1 answer
Can we rollback deleted data in sql
SQL
-1 vote277 views4 answers
Restart mysql server ubuntu
SQL
2 votes299 views3 answers
How do I add a user to a postgres database? cli
SQL