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 vote154 views1 answer
Mysql make date from 2 column
SQL
0 vote135 views1 answer
CREATE MULTIPLE FK
SQL
0 vote126 views0 answer
SQL
0 vote147 views1 answer
How to see password mysql vestacp
SQL
8 votes163 views1 answer
Oracle search stored procedures for text
SQL
0 vote160 views1 answer
Sort by last two number sql
SQL
0 vote142 views1 answer
Distinct data types in a table sql query
SQL
0 vote151 views1 answer
Codeigniter dbforge add index
SQL
21 votes146 views3 answers
Sql average
SQL
0 vote135 views1 answer
Get only first row mysql
SQL