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 vote203 views1 answer
Hashpass
SQL
3 votes176 views2 answers
Sql select data from last week
SQL
1 vote173 views1 answer
What is a Database?
SQL
-2 votes228 views1 answer
Trunc in sql
SQL
0 vote168 views1 answer
Forcefully delete a row in mysql which has references
SQL
7 votes172 views1 answer
Postgres base size
SQL
1 vote183 views1 answer
Sql headers delphi
SQL
3 votes174 views5 answers
Mysql get last inserted id
SQL
0 vote181 views2 answers
Sql searching via key word
SQL
3 votes180 views2 answers
Postgres alter table owner
SQL