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

2 votes342 views1 answer
Q operator in sql
SQL
0 vote370 views2 answers
Fanyi
SQL
23 votes342 views3 answers
Sql where contains part of string
SQL
0 vote318 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote308 views1 answer
Sql string length postgresql
SQL
1 vote294 views2 answers
Into sql
SQL
1 vote312 views1 answer
Sql bitwise operators
SQL
1 vote339 views1 answer
Oracle sequence last_number
SQL
0 vote324 views1 answer
Mysql create pool
SQL
-1 vote354 views1 answer
Brisanje dupliranih konatakata
SQL