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

8 votes180 views1 answer
Sql limit results returned
SQL
0 vote204 views1 answer
Hex string sql becomes int64
SQL
0 vote197 views1 answer
Mod in sql
SQL
0 vote182 views1 answer
Install mysql 8 linux
SQL
0 vote272 views1 answer
Add computed column to table sql server
SQL
36 votes189 views6 answers
Delete from where sql
SQL
3 votes245 views2 answers
Brew restart mysql
SQL
57 votes834 views6 answers
Sql alter table
SQL
0 vote187 views1 answer
Wordpress sql change site url
SQL
0 vote194 views1 answer
Add a new column into table
SQL