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

0 vote113 views1 answer
Sql reverse order of results
SQL
0 vote162 views1 answer
Python mysql check if database exists
SQL
5 votes136 views3 answers
Create function in postgresql
SQL
7 votes107 views5 answers
Oracle alter table
SQL
0 vote102 views1 answer
Select top 3 sql
SQL
0 vote114 views1 answer
Sql select min row
SQL
0 vote137 views1 answer
Sql order by number not ordered
SQL
4 votes114 views2 answers
Error loading MySQLdb module.
SQL
16 votes107 views2 answers
Gremove folder from git
SQL
-1 vote107 views3 answers
SQL to LINQ converter
SQL