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

2 votes262 views1 answer
Sql alchemy or
SQL
0 vote268 views1 answer
SQL SELECT-Klausel
SQL
0 vote290 views2 answers
Select last 30 days sql
SQL
0 vote275 views1 answer
Mysql query to select the highest value
SQL
5 votes278 views4 answers
Restart the psql server windows
SQL
0 vote258 views1 answer
Create new schema mysql
SQL
15 votes260 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote270 views1 answer
Oarcale list objects
SQL
2 votes234 views1 answer
Foreign key example in dbms
SQL
0 vote260 views1 answer
How to connect pgadmin with excel
SQL