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

1 vote346 views3 answers
Mariadb add foreign key
SQL
3 votes375 views2 answers
Find the median in sql
SQL
1 vote339 views1 answer
Postgresql convert text to float
SQL
0 vote365 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
3 votes377 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote367 views1 answer
Sql reverse order of results
SQL
0 vote342 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote328 views1 answer
Check sql query executed wp
SQL
0 vote353 views1 answer
Postgres data location
SQL
0 vote351 views1 answer
Tsql default value when no value returned by query
SQL