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

11 votes167 views2 answers
Set default column value sql
SQL
0 vote164 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote134 views2 answers
How to tun mysql on ubunto
SQL
0 vote134 views1 answer
Sql server bool select
SQL
0 vote173 views1 answer
Bash block size ls /var/lib/mysql
SQL
6 votes142 views2 answers
Psql load dump
SQL
0 vote155 views1 answer
Get enginge db mysql
SQL
0 vote137 views1 answer
How to select all fieldsin a soql query
SQL
0 vote158 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote200 views1 answer
Setting default value for Boolean data type in SQL
SQL