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

16 votes162 views2 answers
Sql vs nosql
SQL
0 vote133 views1 answer
Separator mysql
SQL
0 vote158 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote141 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote186 views2 answers
How to install psql in ubuntu
SQL
0 vote157 views1 answer
Casterar postgres
SQL
0 vote154 views2 answers
Postgresql get long running queries
SQL
0 vote139 views1 answer
Resulting Query
SQL
2 votes152 views1 answer
Postgresql drop primary key constraint
SQL
12 votes138 views2 answers
Delete all data in neo4j
SQL