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 vote201 views2 answers
How to get json data mysql
SQL
1 vote206 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote201 views2 answers
How to tun mysql on ubunto
SQL
0 vote266 views1 answer
Oracle job session
SQL
0 vote212 views1 answer
What is mysql_pconnect
SQL
4 votes201 views2 answers
Mysql show indexes on table
SQL
2 votes222 views3 answers
Sql delete duplicate
SQL
0 vote197 views1 answer
How to export table data from mysql table in sql format
SQL
2 votes225 views1 answer
Removing view
SQL
0 vote225 views1 answer
How to close external sql connection in laravel
SQL