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

7 votes74 views1 answer
Mysql load data infile csv
SQL
0 vote115 views2 answers
T sql null or empty string
SQL
0 vote102 views1 answer
Insert data from stored procedure into table
SQL
4 votes107 views1 answer
Mysql copy table with new name
SQL
0 vote72 views1 answer
Mariadb list tables
SQL
9 votes137 views3 answers
Pyodbc connect to sql server
SQL
0 vote120 views1 answer
Mysql drop vs delete
SQL
0 vote109 views1 answer
Update top 100 order by sql server
SQL
7 votes172 views1 answer
Oracle alter sequence restart start with
SQL
0 vote102 views1 answer
Sql character index
SQL