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

1 vote174 views1 answer
Sql trigger before delete
SQL
-1 vote193 views1 answer
Mysql select count if contains
SQL
-2 votes193 views1 answer
How to open database
SQL
2 votes169 views1 answer
Update with join sql server
SQL
1 vote171 views1 answer
How refresh navicat tables to see new tables
SQL
2 votes206 views2 answers
Install postgresql
SQL
3 votes167 views2 answers
Mysql create database
SQL
0 vote189 views1 answer
Mysql workbench procedure
SQL
13 votes192 views1 answer
Select count of distinct values sql
SQL
0 vote174 views2 answers
Postgres default user
SQL