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

24 votes225 views4 answers
How to add column sql
SQL
1 vote258 views1 answer
Postgres see sequence current state
SQL
0 vote239 views2 answers
Sql max count
SQL
2 votes227 views2 answers
Mysql get time from datetime
SQL
1 vote266 views1 answer
Sql how to replace full stop
SQL
3 votes255 views2 answers
Sqlite show table structure
SQL
1 vote226 views1 answer
Update and replace mysql
SQL
0 vote230 views1 answer
Update set with inner join oracle
SQL
10 votes245 views6 answers
Mysql delete duplicates
SQL
10 votes237 views1 answer
User_dependencies
SQL