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 vote257 views1 answer
Mysql remove last empty newline
SQL
10 votes267 views2 answers
Show tables in schema oracle
SQL
1 vote277 views1 answer
Mysql search like order by best match
SQL
1 vote256 views1 answer
Import in mysql without a software
SQL
0 vote260 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
1 vote271 views1 answer
Sql dcl
SQL
0 vote277 views1 answer
Postgres sequence name
SQL
0 vote279 views1 answer
Postgresql find biggest table
SQL
0 vote266 views1 answer
Soql user profile
SQL
6 votes261 views2 answers
Stored procedure to delete data from table in mysql
SQL