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 vote176 views1 answer
Sql string length postgresql
SQL
1 vote179 views2 answers
Drop function in sql
SQL
0 vote182 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
1 vote218 views1 answer
Postgres count string length
SQL
1 vote232 views1 answer
Postgresql where datetrunc month and year equal
SQL
1 vote170 views4 answers
Between vs in sql
SQL
14 votes177 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
2 votes198 views2 answers
Mysql alter column default
SQL
-1 vote184 views1 answer
Sql oracle take only last results
SQL
3 votes209 views1 answer
Define REGEXP?
SQL