Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting a list of the built-in functions -- what view(s)? Internal?

Bob BrylaJan 4 2020 — edited Jan 5 2020

Would like to get the view or short code that would retrieve the list of Oracle built-in functions -- like TO_CHAR, TO_NUMBER, DUMP, etc.

Tried looking in packages owned by SYS in views like DBA_OBJECTS. Is this list somewhat well delineated? It is from a user-facing documentation perspective ("Single-Row Built In functions"), so getting the list with a query or programatically on the fly would be extremely useful. Thanks.

This post has been answered by Gaz in Oz on Jan 5 2020
Jump to Answer
Comments
Post Details
Added on Jan 4 2020
7 comments
2,047 views