CAST_TO_NUMBER

将Number对应的VARBINARY转化为Number（Oracle的RAW值在神通数据库中具体为VARBINARY类型）

声明

UTL_RAW.CAST_TO_NUMBER (
        r  IN RAW)
RETURN NUMBER;

结构

参数	说明
r	Number对应的RAW。

返回值

返回RAW对应的Number。

示例

create or replace procedure v_cast_to_number
as
DECLARE
  src_num Number;
  res_num Number;
  temp_r VARBINARY;
BEGIN
  src_num := 123;
  temp_r := src_num::varbinary;
  res_num := UTL_RAW.cast_to_number(temp_r); 
  select temp_r as RAW;
  select res_num as RESULT;
END;

/
call v_cast_to_number;
RAW(varbinary)      |
--------------------
0x313233            |
总数目：1
RESULT(numeric)      |
---------------------
123                  |
总数目：1