9.75 V$SQLFN_METADATA
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 Language Reference. |
|
|
Description of the function |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: