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

13 votes347 views2 answers
Sql online compiler
SQL
0 vote377 views1 answer
Mysql average from two table
SQL
0 vote324 views1 answer
How to import sqlite driver class in java using maven
SQL
2 votes330 views1 answer
Mysql find tables with name
SQL
3 votes322 views2 answers
Coalesce mysql
SQL
0 vote332 views1 answer
How to combine rows in sql server procedure
SQL
0 vote317 views1 answer
Mysql error codeigniter
SQL
25 votes347 views1 answer
Mysql grant all privileges to a user
SQL
0 vote372 views1 answer
Cartesian product sql
SQL
0 vote311 views1 answer
Opensuse status MySQL
SQL