HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How can I list all user-owned functions?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
canfunctionsalluserownedhowlist

Problem

Is there a way to quickly list all the current user-owned functions in Oracle?

Something along the same lines as this, which lists the current user's tables

select * from user_tables;

Solution

The answer you are probably looking for is

select * from user_objects where object_type = 'FUNCTION';


However this won't return a list of packaged functions. I'm not aware of anyway of returning these other than by querying user_objects for objects of type 'PACKAGE' and then describing each in turn. Someone with a developer hat on might be able to answer the packaged function part of the question.

Code Snippets

select * from user_objects where object_type = 'FUNCTION';

Context

StackExchange Database Administrators Q#8190, answer score: 8

Revisions (0)

No revisions yet.