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

12 votes349 views1 answer
Run mysql instance in docker
SQL
1 vote269 views1 answer
Mssql string length
SQL
0 vote302 views1 answer
Sql select column names starting with
SQL
0 vote365 views1 answer
Min varias colunas spark sql
SQL
0 vote335 views1 answer
What is top n result in sql
SQL
1 vote316 views2 answers
How to search date in sql query
SQL
0 vote309 views1 answer
Sql create table with datetime automatically
SQL
18 votes302 views2 answers
Sql inner join
SQL
3 votes330 views1 answer
Uppercase and lowercase in sql
SQL
2 votes319 views2 answers
Sql first character
SQL