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 vote319 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote298 views1 answer
Create query in where clasue
SQL
0 vote284 views1 answer
Oracle synonym procedure dblink
SQL
0 vote299 views1 answer
Sql tablo hangi sp de
SQL
0 vote299 views2 answers
Mysql unique two columns
SQL
1 vote310 views1 answer
Mysql check if string contains comma separated
SQL
0 vote309 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
1 vote315 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
1 vote281 views1 answer
Column with prefix in sql
SQL
0 vote282 views1 answer
Sql select all tables from database change url
SQL