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 vote136 views1 answer
Safe mysql
SQL
0 vote119 views1 answer
Mysql does collate nopad recognize space
SQL
2 votes122 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote95 views1 answer
Query for maximum salary
SQL
7 votes128 views1 answer
Set sequence value oracle
SQL
0 vote152 views1 answer
Login failed for user sql server
SQL
0 vote114 views1 answer
How to stop all connections to a psql 12 database?
SQL
16 votes132 views1 answer
CTE statement sql server
SQL
0 vote143 views1 answer
How to fetch data from database in sql
SQL
0 vote133 views1 answer
Oracle flush Shared Pool
SQL