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

3 votes139 views2 answers
MySQL query to get column names
SQL
1 vote124 views1 answer
Setval pgsql
SQL
0 vote129 views1 answer
How to check xampp mysql password
SQL
0 vote128 views1 answer
Subquery aggregation
SQL
0 vote140 views1 answer
Add two days to current date in sql when creating tables
SQL
2 votes128 views2 answers
Oracle multiple insert
SQL
0 vote135 views1 answer
Show table details postgresql
SQL
0 vote125 views1 answer
Doesn't have default value mysql
SQL
0 vote119 views1 answer
Pgadmin see indexes
SQL
0 vote117 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL