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

0 vote200 views2 answers
Wordpress change url after migration mysql query
SQL
1 vote172 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
15 votes176 views2 answers
How to know the username of postgresql
SQL
0 vote176 views1 answer
Db format in quotation
SQL
9 votes168 views4 answers
Add primary key to existing table sql
SQL
2 votes181 views1 answer
How to add where command in update comand with joins
SQL
0 vote232 views1 answer
Sql select without column name
SQL
2 votes224 views1 answer
Sql compare strings
SQL
16 votes180 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
-1 vote199 views1 answer
Mysql select count if contains
SQL