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 vote180 views1 answer
Mysql Install Ubuntu with native password
SQL
4 votes149 views2 answers
Select todays data postgres query
SQL
0 vote189 views2 answers
Temp Space
SQL
0 vote231 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote190 views1 answer
Get last date join sql
SQL
4 votes212 views1 answer
Ms sql truncate table vs delete
SQL
0 vote171 views1 answer
Remove binlog mysql
SQL
0 vote185 views1 answer
Ms sql unique
SQL
0 vote198 views1 answer
Sqlserver now
SQL
3 votes189 views3 answers
Stop mysql service ubuntu
SQL