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 vote204 views1 answer
Separator mysql
SQL
32 votes232 views6 answers
Insert into values select
SQL
0 vote225 views1 answer
Create or replace view postgress
SQL
11 votes227 views3 answers
Change column name sql server management studio
SQL
0 vote219 views1 answer
Inser into example
SQL
2 votes233 views1 answer
Columns Present in a table
SQL
0 vote218 views2 answers
Nosqlbooster query other collection
SQL
4 votes261 views1 answer
Rename stored procedure in sql server
SQL
0 vote233 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote226 views1 answer
Sql contains numeric characters
SQL