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 vote288 views2 answers
T sql null or empty string
SQL
0 vote256 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote278 views1 answer
Mariadb change column type
SQL
0 vote262 views1 answer
Sql server select value large text
SQL
0 vote317 views1 answer
Postgres extract number from string
SQL
1 vote253 views1 answer
Postgresql last element of array
SQL
1 vote286 views1 answer
Drop primary key oracle
SQL
0 vote276 views1 answer
R write csv without index
SQL
0 vote264 views1 answer
Postgres meta command to show all rows in table
SQL
1 vote237 views1 answer
Truncate table in postgresql and reset id
SQL