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

12 votes260 views6 answers
Distinct in sql server
SQL
0 vote245 views1 answer
Second Step in installing SQL workbench
SQL
25 votes228 views4 answers
Metadata
SQL
0 vote236 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote219 views1 answer
Postgres add prefix to primary key
SQL
0 vote230 views1 answer
Sql inserted
SQL
0 vote223 views1 answer
Oracle right characters
SQL
0 vote243 views1 answer
Exit psql
SQL
0 vote228 views1 answer
Postgres 11 add primary key
SQL
2 votes237 views1 answer
While loop sql
SQL