Oracle 视图 V$SQLFN_METADATA 官方解释，作用，如何使用详细说明
本站中文解释
视图
V$SQLFN_METADATA视图是用于存储SQL函数元数据的虚拟视图，它主要包括函数的参数名称、类型、及其它相关信息，该视图存於数据字典中。在Oracle中，可以使用该虚拟视图来查看内部实现SQL函数中使用的参数和类型，以便于进一步理解SQL函数的实现。
使用方法：
1. 获取特定SQL函数及其参数信息：
SELECT * FROM V$SQLFN_METADATA WHERE FN_NAME = ‘特定SQL函数名称’;
2. 获取特定类型SQL函数及其参数信息:
SELECT * FROM V$SQLFN_METADATA WHERE FN_TYPE = ‘特定SQL类型’;
官方英文解释
V$SQLFN_METADATA contains metadata about operators and built-in functions. Note that this view does not contain information about arguments because the number of arguments will be different for various functions. Information about arguments is contained in V$SQLFN_ARG_METADATA, which can be joined with V$SQLFN_METADATA to get information about any function and its arguments.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Internal function identification number |
|
|
|
Name of the built-in function |
|
|
|
Minimum number of arguments for the function |
|
|
|
Maximum number of arguments for the function |
|
|
|
Return data type, which can take any Oracle data type values, data type family values, or ARG[n] data types |
|
|
|
Minimum version of the database that has this function |
|
|
|
Indicates whether the function is an analytic function ( |
|
|
|
Indicates whether the function is an aggregate function ( |
|
|
|
Indicates whether execution of the function can be offloaded to the Oracle Exadata Storage Server ( See Also: Oracle Exadata Storage Server Software documentation for more information |
|
|
|
Function display type:
|
|
|
|
A text explanation of how to use this function. The text is based on the syntax diagram for the function in the Oracle Database SQL |
|
|
|
Description of the function |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“V$SQLFN_ARG_METADATA”
