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

5 votes357 views2 answers
Sql constraint check value in list
SQL
0 vote327 views1 answer
How to create a new shema using query languaage
SQL
0 vote379 views1 answer
Psql create usr
SQL
6 votes320 views2 answers
Return columns from table sql
SQL
0 vote306 views1 answer
Postgresql copy backup table
SQL
1 vote346 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
2 votes335 views1 answer
Set column to not null mysql
SQL
11 votes329 views2 answers
Turn off safe mode mysql
SQL
0 vote337 views5 answers
Select concat alter table mysql
SQL
0 vote311 views1 answer
Sql right characters
SQL