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

2 votes360 views2 answers
How to rename column name in sql server using query
SQL
1 vote340 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
11 votes396 views2 answers
Oracle source code
SQL
1 vote360 views1 answer
Tsql get beginning of year
SQL
3 votes367 views2 answers
Postgres alter table owner
SQL
0 vote378 views2 answers
Default constraint in ms sql
SQL
0 vote346 views1 answer
T sql less than date
SQL
9 votes331 views1 answer
Identity insert on sql server
SQL
1 vote349 views2 answers
Sql select only first occurrence
SQL
-1 vote365 views3 answers
MySQL shutdown unexpectedly
SQL