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 votes169 views1 answer
Sql create database
SQL
3 votes181 views1 answer
Sql print all names that start with a given letter
SQL
0 vote171 views1 answer
Compare two tables to find unmatched records
SQL
1 vote178 views1 answer
Table infromation in sql server
SQL
1 vote173 views1 answer
Show per page table in xampp
SQL
0 vote179 views1 answer
Column ' ' in field list is ambiguous
SQL
28 votes180 views4 answers
Delete database mysql
SQL
1 vote178 views2 answers
Oracle replace
SQL
0 vote164 views1 answer
Sql get month from date
SQL
1 vote188 views1 answer
How to fetch alternate records from two tables
SQL