Oracle list packages

-- 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 vote304 views1 answer
Drop view in mysql
SQL
7 votes284 views3 answers
How ot change name of column mysql
SQL
4 votes256 views2 answers
Tables in sql
SQL
0 vote360 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
13 votes264 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote307 views1 answer
Oracle chain step succeeded
SQL
-1 vote266 views1 answer
How to check table exists or not in postgresql
SQL
2 votes284 views2 answers
Install postgresql
SQL
0 vote273 views1 answer
Exec procedure oracle
SQL
0 vote285 views1 answer
Change filed order in mysql
SQL