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 votes312 views1 answer
Oracle trace file
SQL
6 votes281 views2 answers
Return columns from table sql
SQL
32 votes296 views6 answers
Insert into values select
SQL
0 vote280 views1 answer
Remove default constraint sql server
SQL
11 votes320 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote291 views1 answer
Set mysql socket file docker windows
SQL
2 votes322 views1 answer
Q operator in oracle
SQL
11 votes321 views2 answers
Having clause in sql
SQL
1 vote306 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote295 views2 answers
Starting mysql service from mac
SQL