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 vote141 views1 answer
Search starting with mysql
SQL
7 votes167 views3 answers
Restore postgres database from sql file
SQL
1 vote128 views1 answer
Copy postgres table from one schema into another
SQL
0 vote134 views1 answer
Oracle sql generate list of days
SQL
0 vote137 views2 answers
Oracle create tablespace autoextend
SQL
5 votes135 views3 answers
Mysql check if null or empty string
SQL
0 vote117 views1 answer
Login phpmyadmin without password
SQL
13 votes128 views2 answers
Check if value is null mysql
SQL
12 votes139 views1 answer
Psql drop column
SQL
0 vote172 views1 answer
Install postgresql 12 on debian 10
SQL