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

1 vote130 views2 answers
Postgres cast as decimal
SQL
0 vote200 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote144 views1 answer
Sql select column name like from multiple tables
SQL
0 vote140 views1 answer
Influxdb clone measurement
SQL
-1 vote144 views1 answer
Phinehas Psalm 106
SQL
0 vote127 views1 answer
Check connections to database postgres
SQL
0 vote148 views1 answer
Postgres grep entire database
SQL
0 vote128 views2 answers
Mysql output csv
SQL
0 vote133 views1 answer
Denormalise SQL command
SQL
0 vote132 views1 answer
Psql attribute cannot login
SQL