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

5 votes219 views1 answer
Sql check if date is between 2 dates
SQL
5 votes210 views2 answers
Postgre insert select
SQL
0 vote220 views1 answer
Mysql set column equal to another automatic
SQL
4 votes221 views2 answers
Show all database inside postgresql
SQL
0 vote249 views1 answer
Mysql get nested records
SQL
0 vote221 views1 answer
Convert excel into sqllite db using python
SQL
3 votes232 views1 answer
DB: in eloquent using sql
SQL
1 vote226 views1 answer
Oracle schema size
SQL
1 vote210 views1 answer
Truncate left characters mysql
SQL
1 vote217 views1 answer
Sql find column name like
SQL