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

1 vote292 views1 answer
Join first name and last name sql
SQL
0 vote286 views1 answer
Mariadb hours between two dates
SQL
0 vote269 views1 answer
Sqlite referential integrity
SQL
0 vote301 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
3 votes302 views1 answer
Mysql insert on dupèlicate
SQL
0 vote387 views2 answers
Sqlalchemy default value for column
SQL
0 vote279 views1 answer
Get foreign table names mysql
SQL
0 vote280 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote299 views1 answer
Postgresql check total storage
SQL
0 vote281 views1 answer
Can sqldatareader be null
SQL