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 vote144 views1 answer
T-SQL Create Trigger
SQL
1 vote130 views1 answer
Oracle check table space
SQL
0 vote129 views1 answer
Vbscript create ADODB.Connection
SQL
1 vote140 views1 answer
Calculate age in sql postgresql
SQL
0 vote136 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote141 views3 answers
Duplicate row mysql
SQL
7 votes150 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote170 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote139 views1 answer
How to print some string in mysql
SQL
0 vote149 views1 answer
Sql server create constraint
SQL