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 vote178 views1 answer
Sqlalchemy query join many to many
SQL
0 vote175 views1 answer
Delete record by id sql
SQL
0 vote158 views1 answer
Postgres get running query
SQL
7 votes169 views2 answers
Sql server drop temp table if exists
SQL
10 votes158 views3 answers
Insert into auto increment mysql
SQL
6 votes127 views2 answers
Spring data jpa application.properties mysql
SQL
23 votes167 views6 answers
How to create table in sql
SQL
4 votes166 views1 answer
What are the data types in sql
SQL
0 vote212 views1 answer
How to subquey to do not load in live database in
SQL
0 vote170 views1 answer
Set a default value for a column in sqlite
SQL