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 vote325 views1 answer
Mysql return if it contains
SQL
5 votes322 views2 answers
Sql conn
SQL
0 vote309 views2 answers
Create fulltext index mysql
SQL
0 vote301 views3 answers
Sql select statements
SQL
0 vote313 views1 answer
Automated psql csv export script on windows
SQL
2 votes312 views1 answer
Removing view
SQL
3 votes324 views1 answer
Unsigned int in mysql
SQL
4 votes310 views2 answers
Oracle last day of month
SQL
7 votes310 views3 answers
Python and mysql connectivity
SQL
5 votes298 views3 answers
String concatenation sql server
SQL