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

8 votes184 views5 answers
Alter table add column with default value
SQL
0 vote226 views1 answer
Mysl like insert a variable
SQL
2 votes168 views1 answer
Ifnull postgres
SQL
0 vote212 views1 answer
Mysql config slave
SQL
33 votes187 views6 answers
Sql delete
SQL
0 vote180 views1 answer
Mysql create table columns with spaces
SQL
7 votes190 views3 answers
Python and mysql connectivity
SQL
0 vote276 views1 answer
Having all mysql
SQL
0 vote297 views1 answer
Insensitive case match sqlalchemy
SQL
-1 vote182 views1 answer
Mysql order by on condition
SQL