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 vote299 views1 answer
Table valued functions in sql
SQL
0 vote307 views1 answer
Change date format in oracle query
SQL
8 votes389 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote286 views1 answer
Mysql error 1452
SQL
8 votes297 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote279 views1 answer
Sample clause in sql
SQL
0 vote297 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote295 views1 answer
How to find symmetric pairs in sql
SQL
0 vote288 views1 answer
Flush user resource mysql
SQL
0 vote279 views1 answer
Create database store
SQL