Oracle show procedures

-- 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');

Oracle show procedures

-- Specifically for SQL:Oracle

SELECT * 
FROM ALL_PROCEDURES;

Similar codes

4 votes107 views1 answer
Mac install mysql
SQL
0 vote107 views1 answer
Mysql zerofill
SQL
0 vote113 views1 answer
Add SuperUser MySQL
SQL
0 vote110 views1 answer
Delete data from database sqlite android
SQL
0 vote109 views1 answer
Bidirectional outer join sql
SQL
0 vote110 views4 answers
What is unique key in sql
SQL
18 votes97 views3 answers
Mysql add column with default value
SQL
5 votes60 views1 answer
Postgres upsert
SQL
0 vote115 views2 answers
Advantages of stored procedures sql
SQL
-1 vote106 views1 answer
Mac mysql workbench console
SQL