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 vote262 views1 answer
Mysql sort by date column
SQL
0 vote226 views1 answer
Virtuoso sql query tutorial
SQL
0 vote209 views1 answer
Check if a column is a primary key in sql server
SQL
3 votes194 views1 answer
Locate sql server
SQL
0 vote191 views2 answers
Start mysql server using docker
SQL
2 votes191 views6 answers
In in sql
SQL
25 votes213 views5 answers
Uninstall mysql ubuntu
SQL
1 vote195 views1 answer
Convert epoch to date in sql server
SQL
0 vote192 views1 answer
Mysql table variables
SQL
3 votes198 views1 answer
Oracle list invalid password ORA-01017
SQL