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 vote326 views1 answer
Sql select max value from multiple rows
SQL
0 vote322 views1 answer
Normalization in database 2nd normal form
SQL
0 vote337 views1 answer
Postgresql port 5432 not open
SQL
0 vote322 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote332 views1 answer
One table with another
SQL
1 vote317 views1 answer
Sql how to duplicate a table
SQL
2 votes304 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote326 views1 answer
SQL Server Enterprise
SQL
9 votes330 views5 answers
Laravel to sql
SQL
0 vote317 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL