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 vote179 views1 answer
Space not removing from column in sql
SQL
0 vote164 views1 answer
Drop database using terminal postgres
SQL
0 vote147 views1 answer
Select all tables linked server sql
SQL
0 vote164 views1 answer
Create a sql server database programmatically
SQL
0 vote152 views1 answer
Show create table in postgresql
SQL
17 votes179 views2 answers
Mysql date to string
SQL
1 vote402 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote158 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote159 views2 answers
Mysql dump database tables only
SQL
0 vote166 views4 answers
What is unique key in sql
SQL