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 vote216 views1 answer
Sqlalchemy existing database
SQL
0 vote280 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote266 views1 answer
Sql server split string and insert into table select
SQL
35 votes320 views5 answers
Sql alter column
SQL
0 vote299 views1 answer
Cahnge column name apex oracle
SQL
0 vote284 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote245 views1 answer
Psql show with user is logged in
SQL
0 vote320 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
1 vote271 views2 answers
Mysql insert generate serie
SQL
0 vote263 views1 answer
How to print out column name differently in mysql
SQL