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

1 vote187 views1 answer
Can we drop a primary key
SQL
2 votes206 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote219 views1 answer
SQL server datetime compare
SQL
0 vote206 views1 answer
Raiserror with nowait
SQL
4 votes194 views1 answer
To date oracle with time
SQL
3 votes198 views2 answers
Plsql print
SQL
0 vote221 views1 answer
Sql query wordpress export post
SQL
1 vote217 views2 answers
Postgresql truncate cascade restart identity
SQL
1 vote201 views2 answers
Mysql update table from another table
SQL
31 votes195 views3 answers
Sql count(*)
SQL