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 vote178 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote172 views1 answer
Mssql now diff 90 day
SQL
2 votes175 views1 answer
Convert series number to date in sql
SQL
0 vote210 views1 answer
SQL-Arten
SQL
7 votes179 views1 answer
Query postgres delete duplicates
SQL
1 vote182 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote168 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote162 views1 answer
Sql server bool select
SQL
0 vote168 views1 answer
Oracle right characters
SQL
0 vote189 views1 answer
Change filed order in mysql
SQL