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 vote339 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote357 views1 answer
Postgresql datetrunc too slow
SQL
0 vote319 views1 answer
Store query result in variable sql
SQL
5 votes381 views4 answers
Traduction
SQL
4 votes349 views4 answers
Pl sql output
SQL
0 vote344 views1 answer
Mysql select where field like in list
SQL
-1 vote360 views1 answer
Auto increment psql not primary key
SQL
-1 vote339 views3 answers
Create temp table in sql
SQL
0 vote334 views2 answers
Sql drop view if exists
SQL
0 vote326 views1 answer
Postgres add prefix to primary key
SQL