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 vote71 views1 answer
Strict in postgres SQL
SQL
0 vote100 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote107 views1 answer
Datagrip go to line
SQL
2 votes145 views1 answer
How to select from mssql
SQL
0 vote134 views1 answer
Postgres full text search example
SQL
0 vote112 views2 answers
Create row number in sql
SQL
0 vote108 views1 answer
Select multiple row from primary key sql
SQL
10 votes121 views2 answers
What is database
SQL
0 vote109 views1 answer
Show tables in cassandra cql
SQL
3 votes113 views2 answers
Sql random integer
SQL