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

1 vote337 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote315 views1 answer
MySql get primary keys of table
SQL
0 vote320 views1 answer
Restore backupfile discourse
SQL
4 votes355 views2 answers
Oracle drop job
SQL
2 votes310 views1 answer
Oracle sql drop table purge
SQL
1 vote314 views1 answer
Loading local data is disabled mysql
SQL
0 vote319 views1 answer
Sqlalchemy sequence postgresql
SQL
7 votes287 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote361 views1 answer
How to change mysql root password in windows 10
SQL
0 vote346 views1 answer
Sql delimiter to columns
SQL