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 vote253 views1 answer
Sql alter table add column if exists
SQL
2 votes172 views4 answers
Duplicate record mysql
SQL
0 vote141 views2 answers
Jupyter notebook connect to database
SQL
2 votes305 views1 answer
Tsql copy table
SQL
1 vote195 views1 answer
Mysql curdate between two dates
SQL
1 vote178 views1 answer
Neo4j display all nodes and relationships
SQL
7 votes180 views2 answers
Add column table pl sql
SQL
2 votes188 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote340 views2 answers
Create new table from existing table with data in sql server
SQL
6 votes205 views1 answer
To count number of rows in SQL table
SQL