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

8 votes178 views3 answers
SQL column name
SQL
11 votes199 views2 answers
Import sql file laravel cmd
SQL
-1 vote200 views1 answer
Mysql faster insert
SQL
3 votes161 views2 answers
Postgresql remove not null constraint
SQL
0 vote164 views1 answer
Groupby error in mysql
SQL
11 votes213 views2 answers
Having keyword sql
SQL
5 votes170 views3 answers
Mysql extract month from date
SQL
0 vote195 views2 answers
What is rownum in oracle
SQL
0 vote168 views1 answer
Postgres where
SQL
5 votes184 views6 answers
Sql foreign key
SQL