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 vote114 views1 answer
Object Information
SQL
0 vote116 views1 answer
Insert array into mysql column
SQL
1 vote113 views7 answers
Filter
SQL
2 votes131 views1 answer
Sql string starts with
SQL
15 votes124 views6 answers
Laravel db transaction
SQL
0 vote99 views1 answer
Oracle list chain steps
SQL
11 votes112 views2 answers
Oracle all source
SQL
3 votes141 views3 answers
Sql current year
SQL
0 vote115 views1 answer
Sql select duplicates based on two columns
SQL
0 vote131 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL