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 votes131 views2 answers
Delete entries in postgresql
SQL
0 vote122 views1 answer
Sqlite to csv statement
SQL
3 votes129 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
1 vote160 views1 answer
Hangfire clear all jobs
SQL
17 votes142 views3 answers
How to change a collumn name in sql
SQL
1 vote132 views1 answer
Sql drop with dependencies
SQL
0 vote139 views1 answer
Two inner joins sql
SQL
3 votes137 views3 answers
Postgresql random number
SQL
0 vote161 views1 answer
Get total and distict row diff in sql
SQL
0 vote134 views1 answer
How to install mysql without admin rights
SQL