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

3 votes255 views2 answers
Sql add year to date
SQL
8 votes190 views8 answers
Second highest salary in mysql
SQL
0 vote231 views1 answer
Postgres read table structure
SQL
0 vote216 views1 answer
Getting next sequence value jpa postgress
SQL
1 vote235 views1 answer
Mysql size int
SQL
0 vote231 views1 answer
Print hello world in plsql
SQL
1 vote217 views1 answer
Sql delete all values in a column
SQL
13 votes245 views3 answers
Change data type postgresql
SQL
1 vote223 views1 answer
Oracle case
SQL
0 vote223 views1 answer
Sql query interview questions githu
SQL