The CONVERT* static functions are used to fully construct an ANYDATA value in a single call, converting a value of a specified data type to ANYDATA and returning the result.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
STATIC FUNCTION ConvertNumber(num IN NUMBER) return AnyData;
STATIC FUNCTION ConvertDate(dat IN DATE) return AnyData;
STATIC FUNCTION ConvertChar(c IN CHAR) return AnyData;
STATIC FUNCTION ConvertVarchar(c IN VARCHAR) return AnyData;
STATIC FUNCTION ConvertVarchar2(c IN VARCHAR2) return AnyData;
STATIC FUNCTION ConvertRaw(r IN RAW) return AnyData;
STATIC FUNCTION ConvertBlob(b IN BLOB) return AnyData;
STATIC FUNCTION ConvertClob(c IN CLOB) return AnyData;
STATIC FUNCTION ConvertObject(obj IN "<ADT_1>") return AnyData;
STATIC FUNCTION ConvertCollection(col IN "<COLLECTION_1>") return AnyData;
STATIC FUNCTION ConvertTimestamp(ts IN TIMESTAMP_UNCONSTRAINED) return AnyData;
STATIC FUNCTION ConvertTimestampTZ(ts IN TIMESTAMP_TZ_UNCONSTRAINED) return AnyData;
STATIC FUNCTION ConvertTimestampLTZ(ts IN TIMESTAMP_LTZ_UNCONSTRAINED) return AnyData;
STATIC FUNCTION ConvertIntervalYM(inv IN YMINTERVAL_UNCONSTRAINED) return AnyData;
STATIC FUNCTION ConvertIntervalDS(inv IN DSINTERVAL_UNCONSTRAINED) return AnyData;
STATIC FUNCTION ConvertNchar(nc IN NCHAR) return AnyData;
STATIC FUNCTION ConvertNVarchar2(nc IN NVARCHAR2) return AnyData;
STATIC FUNCTION ConvertBFloat(fl IN BINARY_FLOAT) return AnyData;
STATIC FUNCTION ConvertBDouble(dbl IN BINARY_DOUBLE) return AnyData;
STATIC FUNCTION ConvertURowid(rid IN UROWID) return AnyData;
Parameters
Parameter |
Description |
|---|---|
| num、dat、c、r、b、obj、col、ts、inv、nc、fl、dbl、rid | To be converted intoANYDATAThe source data value, whose type is determined by the function being called. |
Return value
Returns ANYDATA, which encapsulates the source data value and its type information.
Usage instructions
- For
ConvertObjectandConvertCollection, the passed object or collection cannot beNULL; otherwise, an error will be reported.