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 vote148 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote170 views1 answer
Tsql replace value in json
SQL
11 votes236 views1 answer
Oracle insert from select
SQL
0 vote144 views1 answer
Mysql jdbc timezone
SQL
0 vote148 views1 answer
How to add session data into mysql database from button
SQL
2 votes151 views1 answer
Pandas to sql index
SQL
3 votes152 views2 answers
Mysql HAVING
SQL
7 votes169 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote169 views1 answer
Sql convert unix time to date
SQL
0 vote177 views10 answers
John the ripper mysql
SQL