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 vote232 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote236 views1 answer
Sql grant select only
SQL
0 vote223 views1 answer
How to create a table in sql stack overflow
SQL
0 vote213 views1 answer
Reset keys in sql
SQL
1 vote271 views1 answer
How to show index type in postgresql
SQL
0 vote233 views1 answer
Mysql get hour from datetime
SQL
7 votes208 views2 answers
Mysql check db size
SQL
1 vote204 views1 answer
Set mysql mode global query
SQL
9 votes206 views2 answers
Default number in sql
SQL
3 votes216 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL