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 vote356 views1 answer
Multiple row join
SQL
0 vote180 views1 answer
Typeorm raw sql
SQL
0 vote207 views1 answer
How much space does sql server take per row
SQL
0 vote183 views2 answers
Mysql multiply
SQL
1 vote167 views1 answer
Sql server select rows by distinct column
SQL
0 vote190 views1 answer
Sql ignore
SQL
0 vote198 views1 answer
How to find lowest in sql
SQL
1 vote188 views1 answer
Name of today sql
SQL
7 votes198 views1 answer
Sql limit decimal places
SQL
5 votes138 views1 answer
Postgres upsert
SQL