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 vote128 views1 answer
Is not sql
SQL
0 vote129 views1 answer
C# get sql min date
SQL
0 vote114 views1 answer
Oracle create job if not exists
SQL
1 vote118 views1 answer
Postgres get timestamp
SQL
0 vote108 views1 answer
Mysql cdn link
SQL
0 vote76 views1 answer
Sql count how many times a value appears
SQL
0 vote128 views2 answers
Clauses in mysql
SQL
0 vote114 views1 answer
Mysql grouping functions
SQL
11 votes111 views2 answers
Sql between date range
SQL
1 vote120 views1 answer
Order by oracle
SQL