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

4 votes171 views1 answer
Postgresql change default value
SQL
0 vote140 views1 answer
How to write if case in select query in select statement
SQL
0 vote126 views1 answer
Select value from previous row in postgresql
SQL
5 votes96 views1 answer
Mongodb vs
SQL
0 vote142 views1 answer
Sql server alter table add column tinyint
SQL
0 vote136 views1 answer
Change permission to database mysql
SQL
5 votes138 views1 answer
Oracle sysdate
SQL
6 votes157 views2 answers
Mysql timestamp to date
SQL
3 votes182 views1 answer
Query less than datetime sql
SQL
1 vote143 views1 answer
Sqlalchemy order by descending
SQL