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 vote196 views2 answers
Unique key
SQL
1 vote206 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote192 views1 answer
Select from another database
SQL
0 vote209 views1 answer
Mysql milliseconds
SQL
0 vote197 views1 answer
Supprimer les valeur d'une table mysql
SQL
5 votes202 views1 answer
Mysql add user with all privileges
SQL
1 vote173 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote214 views2 answers
Drop table with constraints
SQL
8 votes220 views1 answer
Oracle search text in all packages
SQL
6 votes192 views2 answers
Join vs union
SQL