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

8 votes344 views3 answers
Connect python to mysql
SQL
0 vote325 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote333 views1 answer
Mysql query problems and solutions
SQL
0 vote335 views1 answer
Set a default value for a column in sqlite
SQL
13 votes391 views3 answers
Mysqldump structure only
SQL
0 vote344 views1 answer
Mysql aspas simples
SQL
0 vote323 views1 answer
Postgres jsonb array push new element
SQL
0 vote329 views3 answers
Sql all columns
SQL
3 votes336 views1 answer
Null sql
SQL
1 vote368 views1 answer
Sql server if exists update else insert
SQL