Oracle内置函数元数据 [英] Oracle built-in functions metadata

问题描述

是否可以获取Oracle内置的aggeregate和其他功能(例如AVG, STDDEV, SQRT,等)的元数据? 我需要知道对象ID和参数元.

Is there a way to get metadata for the Oracle built-in aggeregate and other functions such as AVG, STDDEV, SQRT, etc.? I need to know object id and arguments meta.

在SYS.ALL_OBJECTS视图中，我找不到任何有用的东西.我还尝试过在SYS.ALL_ARGUMENTS视图中按object_name搜索.

In the SYS.ALL_OBJECTS view I couldn't find anything useful. I also tried to search in SYS.ALL_ARGUMENTS view by object_name.

是否存在具有类似于SYS.ALL_OBJECTS和SYS.ALL_ARGUMENTS的数据的内置函数的视图或表?

Is there views or tables with built-in functions with data similar to SYS.ALL_OBJECTS and SYS.ALL_ARGUMENTS?

推荐答案

您已标记Oracle 10g，

You have tagged Oracle 10g, but from what I can find, you'll need Oracle 11g r1 to find out metadata on built-in SQL functions.

您可以通过动态性能视图V$SQLFN_METADATA(具有常规元数据)和V$SQLFN_ARG_METADATA(具有有关参数的元数据)来查看SQL内置函数的元数据.

You can see metadata for SQL built-in functions with the dynamic performance views V$SQLFN_METADATA (which has general metadata) and V$SQLFN_ARG_METADATA (which has metadata about arguments).

您可以在FUNCID列上加入这些视图.对于具有无限参数的函数(例如LEAST和GREATEST)，V $ SQLFN_ARG_METADATA的每个重复参数只有一行.

You can join these views on the column FUNCID. For functions with unlimited arguments, such as LEAST and GREATEST, V$SQLFN_ARG_METADATA has only one row for each repeating argument.

这篇关于Oracle内置函数元数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！