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

2 votes116 views1 answer
Oracle log files
SQL
0 vote133 views1 answer
Limit in access query
SQL
1 vote110 views1 answer
Adding a default constraint to an existing column in sql
SQL
1 vote122 views1 answer
Mysql decimal allow negative values?
SQL
0 vote110 views1 answer
How to create an SQL save method in ruby
SQL
1 vote118 views1 answer
Get url of cpanel database hostname
SQL
0 vote115 views1 answer
Sql query contains multiple ids
SQL
0 vote110 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
3 votes110 views2 answers
Laravel tosql with bindings
SQL
0 vote146 views1 answer
How to add auto increment primary key
SQL