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 vote137 views1 answer
Postgresql inline table
SQL
0 vote120 views1 answer
Sql create text column limited values
SQL
12 votes121 views4 answers
Import mysql database command line linux
SQL
14 votes129 views1 answer
Oracle alter table add column not null
SQL
2 votes130 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote122 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote124 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote112 views1 answer
Mysql cdn link
SQL
0 vote84 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
8 votes123 views1 answer
Sql remove leading spaces
SQL