snippetMinor
How can I list all user-owned functions?
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
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
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.
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.