The CAST_TO_NVARCHAR2 function converts a RAW value represented by a specific number of bytes into a NVARCHAR2 value with the same number of bytes.
Applicability This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
UTL_RAW.CAST_TO_NVARCHAR2 (
r IN RAW)
RETURN NVARCHAR2;
Parameters
r indicates the RAW value (without a leading length field) to be converted into a NVARCHAR2 value.
Return values
A NVARCHAR2 value is returned. This value contains the same data of the input RAW value.
Examples
obclient> SELECT UTL_RAW.CAST_TO_NVARCHAR2('3C55') FROM DUAL;
+-----------------------------------+
| UTL_RAW.CAST_TO_NVARCHAR2('3C55') |
+-----------------------------------+
| 㱕 |
+-----------------------------------+
1 row in set