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 vote122 views1 answer
Double in sql server example
SQL
7 votes162 views2 answers
Oracle foreign key reference table
SQL
9 votes122 views2 answers
Oracle all tables in schema
SQL
0 vote128 views2 answers
Timing sql queries
SQL
0 vote181 views1 answer
Import sql dump into postgresql database
SQL
1 vote124 views1 answer
Input in mysql
SQL
1 vote124 views1 answer
Postgres convert date to string
SQL
9 votes120 views6 answers
Sql insert into
SQL
0 vote119 views1 answer
Sql server 2012 create or alter procedure
SQL
1 vote137 views1 answer
Increase date by one day in sql oracle
SQL