Oracle list functions

-- 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 vote347 views1 answer
Helptext in sql
SQL
0 vote351 views1 answer
SAP Return
SQL
10 votes364 views3 answers
Sql select between two dates
SQL
1 vote353 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote363 views1 answer
Sql query use select name inside where clause
SQL
0 vote392 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote343 views1 answer
Sql revert migration
SQL
3 votes403 views2 answers
Wp do sql query from function
SQL
0 vote313 views1 answer
How many columns can be used for creating index?
SQL
0 vote357 views1 answer
Sql change column in existing table
SQL