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 vote133 views1 answer
How to to get current date and time in sql
SQL
0 vote149 views2 answers
Sql query in dax power bi
SQL
4 votes155 views1 answer
Conda install sqlalchemy
SQL
0 vote155 views2 answers
Starts and end with vowel sql
SQL
0 vote97 views1 answer
Procedures and functions in pl/sql
SQL
0 vote154 views2 answers
Replace null with 0 in sql
SQL
1 vote137 views1 answer
How to see logical reads in sql server
SQL
0 vote161 views1 answer
Postgresql show owner of database
SQL
0 vote144 views1 answer
Mysql query to add hours to column in table
SQL
9 votes149 views3 answers
Mysql run sql file
SQL