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 vote172 views5 answers
Mode sql course
SQL
0 vote174 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
3 votes172 views1 answer
Locate sql server
SQL
3 votes163 views1 answer
Postgres kill running query
SQL
0 vote246 views1 answer
Get last inserted primary key
SQL
52 votes801 views6 answers
Rename column sql
SQL
0 vote160 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote184 views1 answer
Sql last 3 rows
SQL
0 vote213 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
16 votes163 views1 answer
Sqlserver add column to table
SQL