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 vote200 views1 answer
Insert array into mysql column
SQL
0 vote183 views1 answer
CREATE MULTIPLE FK
SQL
0 vote233 views1 answer
How to find date from date table in sql
SQL
0 vote242 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote261 views1 answer
How do you insert boolean to postgresql
SQL
17 votes195 views3 answers
Cast in sql server
SQL
0 vote301 views1 answer
Mysql grant access to one database
SQL
3 votes302 views3 answers
Mysql get table size
SQL
1 vote187 views1 answer
Sql alchemy with azuresql server
SQL
2 votes186 views1 answer
Plsql block
SQL