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 vote299 views1 answer
How to alter length character varying postgres
SQL
11 votes304 views1 answer
Get ddl materialized view oracle
SQL
0 vote298 views1 answer
VSCode SQL Server Connection error
SQL
0 vote318 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote308 views1 answer
Insert or update sql firebird
SQL
2 votes275 views1 answer
Plsql left() function
SQL
0 vote304 views1 answer
Pgsql is not permitted to log in
SQL
0 vote302 views1 answer
Sqlalchemy get schema from database
SQL
0 vote311 views1 answer
Top 3 salary in sql
SQL
6 votes296 views2 answers
Where clause in sql
SQL