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 vote123 views1 answer
Mysql config address
SQL
0 vote121 views1 answer
Remove binlog mysql
SQL
0 vote171 views1 answer
Sql pivot table
SQL
0 vote133 views1 answer
Sql server count all tables rows
SQL
0 vote129 views1 answer
Mariadb cast to int
SQL
3 votes120 views1 answer
Delete all content in table mysql
SQL
4 votes128 views1 answer
Mysql timestamp in laravel migration
SQL
3 votes142 views2 answers
Find string in stored procedure sql server
SQL
0 vote133 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
2 votes137 views1 answer
Node and mysql like
SQL