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 vote272 views1 answer
Sql server update top n records
SQL
5 votes286 views1 answer
Oracle ORA-00054 origin
SQL
10 votes290 views5 answers
Mysql create user
SQL
0 vote273 views1 answer
Getting next sequence value jpa postgress
SQL
1 vote295 views1 answer
How to remove identity from a column in sql server
SQL
0 vote262 views1 answer
Mysql select distinct date from timestamp
SQL
8 votes295 views1 answer
Script to add datafile to tablespace
SQL
2 votes302 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote302 views1 answer
Uncheck constraints and delete from table
SQL
5 votes312 views1 answer
Sql integer to serial
SQL