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 vote353 views1 answer
Postgresql heritage
SQL
3 votes396 views2 answers
How to delete git repo locally
SQL
0 vote365 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote368 views1 answer
Sqlite commands
SQL
5 votes341 views1 answer
Oracle asynchronous query
SQL
4 votes351 views1 answer
Sql group by year
SQL
3 votes420 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote345 views1 answer
Mariadb number format
SQL
3 votes341 views2 answers
Oracle synonym
SQL
0 vote369 views1 answer
Sql server on mac m1
SQL