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 vote282 views1 answer
Postgresql in vs any performance
SQL
0 vote318 views1 answer
Sql query inline if
SQL
0 vote266 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
9 votes256 views2 answers
Default number in sql
SQL
0 vote276 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote296 views1 answer
Count columns psql(PostreSQL)
SQL
4 votes305 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
1 vote301 views3 answers
Sql union
SQL
2 votes299 views3 answers
Sql truncate table
SQL
0 vote278 views1 answer
Postgresql comandos basicos
SQL