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

1 vote225 views1 answer
Select last row from SQL Table
SQL
0 vote192 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote169 views1 answer
Sql create text column limited values
SQL
0 vote185 views1 answer
Sqlserver now
SQL
0 vote159 views1 answer
How to change null display in psql
SQL
0 vote247 views1 answer
Mariadb date equals to current_date plus days
SQL
-1 vote198 views1 answer
Mysql delete duplicate rows except one
SQL
11 votes196 views3 answers
Sql line numbers
SQL
0 vote176 views2 answers
Create sequence if not exists postgres
SQL
7 votes177 views1 answer
Mysql remote connection command line
SQL