Oracle list functions

-- 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');

Similar codes

1 vote322 views2 answers
Backup table mssql
SQL
2 votes354 views1 answer
Datefromparts mssql
SQL
0 vote294 views1 answer
Database timezone
SQL
0 vote318 views1 answer
Oracle table free space
SQL
0 vote348 views1 answer
Create a view in sqlite
SQL
0 vote306 views1 answer
Docker open terminal mysql server
SQL
0 vote297 views1 answer
Output table plsql
SQL
0 vote308 views1 answer
Sql #region
SQL
3 votes322 views2 answers
To_char sql
SQL
0 vote301 views1 answer
Mysql date minus 1 day
SQL