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 vote119 views2 answers
Remove space in mysql
SQL
0 vote111 views1 answer
Java check if something is in mysql table
SQL
3 votes215 views6 answers
Sql unique select
SQL
0 vote122 views1 answer
Drop all data from tables
SQL
0 vote106 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote109 views1 answer
Mysql check datetime equals date
SQL
-1 vote159 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
1 vote59 views1 answer
Mysql collation
SQL
1 vote102 views2 answers
Sql for date greater than
SQL
1 vote101 views2 answers
Install mysqldump ubuntu
SQL