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

10 votes191 views4 answers
Join with multiple conditions sql
SQL
0 vote190 views1 answer
Change date format in oracle query
SQL
3 votes188 views2 answers
Postgres download
SQL
0 vote172 views1 answer
Mysql select where text contains
SQL
4 votes210 views1 answer
What are the data types
SQL
0 vote188 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote180 views1 answer
Create database store
SQL
1 vote200 views1 answer
Mysql update inner
SQL
0 vote172 views1 answer
If null don't update
SQL
0 vote182 views1 answer
Mysql count unique in group statement
SQL