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

0 vote139 views1 answer
Sql server select ignore dupplicates
SQL
3 votes133 views2 answers
Postgres inner join vs join
SQL
0 vote145 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote140 views2 answers
How to save result of sqlite query in a table
SQL
1 vote135 views1 answer
Sql trigger before delete
SQL
0 vote153 views1 answer
Sql convert float to string
SQL
23 votes144 views3 answers
Sql where contains part of string
SQL
2 votes209 views1 answer
Mysql create user with remote access
SQL
0 vote158 views1 answer
Repeatable read trong sql server
SQL
0 vote168 views1 answer
Day of the week sqlite
SQL