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 vote287 views1 answer
Oracle avg
SQL
8 votes365 views3 answers
Find table for column name in sql
SQL
0 vote290 views1 answer
Mysql count unique in group statement
SQL
0 vote284 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote297 views1 answer
Sql developer search all packages for text
SQL
1 vote296 views1 answer
ORA-01950
SQL
1 vote308 views2 answers
Snowflake alter column data type
SQL
2 votes280 views1 answer
Node and mysql like
SQL
20 votes297 views6 answers
Creating a table in sql
SQL
0 vote283 views1 answer
Unique index in mysql
SQL