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

8 votes347 views1 answer
Oracle add months to sysdate
SQL
8 votes333 views5 answers
Alter table add column with default value
SQL
0 vote336 views1 answer
Order by ip address sql
SQL
0 vote353 views1 answer
How to access to mysql without root
SQL
24 votes378 views5 answers
List mysql users
SQL
20 votes361 views6 answers
Mysql reset auto increment
SQL
7 votes374 views2 answers
Mysql check db size
SQL
-1 vote364 views8 answers
Create Trigger in phpMyAdmin
SQL
23 votes349 views3 answers
Mysqldump
SQL
0 vote346 views1 answer
Mysql select all table that have field names
SQL