Oracle-RAW类型基本操作函数和使用示例.docx

RAW类型是Oracle中用于保存位串的一种数据类型，类似于CHAR，使用RAW（L) 方式声明，最长可达32767字节。系统提供了一个SYS.utl_raw工具包用于RAW类型的操作，常用的函数如下：1、长度计算函数，得到一个raw类型变量的长度，单位为字节??FUNCTION?length(r?IN?RAW)?RETURN?NUMBER;如：select?utl_raw.length?from?dual;结果为:42、拼接函数，用于拼接两个raw类型变量??FUNCTION?concat(r1??IN?RAW?DEFAULT?NULL,????????????????? r2??IN?RAW?DEFAULT?NULL,????????????????? r3??IN?RAW?DEFAULT?NULL,????????????????? r4??IN?RAW?DEFAULT?NULL,????????????????? r5??IN?RAW?DEFAULT?NULL,????????????????? r6??IN?RAW?DEFAULT?NULL,????????????????? r7??IN?RAW?DEFAULT?NULL,????????????????? r8??IN?RAW?DEFAULT?NULL,????????????????? r9??IN?RAW?DEFAULT?NULL,????????????????? r10?IN?RAW?DEFAULT?NULL,????????????????? r11?IN?RAW?DEFAULT?NULL,????????????????? r12?IN?RAW?DEFAULT?NULL)?RETURN?RAW;如：select?utl_raw.concat(12,34)?from?dual;结果为:12343、获取子串函数??FUNCTION?substr(r???IN?RAW,????????????????? pos?IN?BINARY_INTEGER,????????????????? len?IN?BINARY_INTEGER?DEFAULT?NULL)?RETURN?RAW;如：select?utl_raw.substr2,1)?from?dual;结果为：344、位操作函数??FUNCTION?bit_and(r1?IN?RAW,?????????????????? r2?IN?RAW)?RETURN?RAW;??FUNCTION?bit_or(r1?IN?RAW,????????????????? r2?IN?RAW)?RETURN?RAW;??FUNCTION?bit_xor(r1?IN?RAW,?????????????????? r2?IN?RAW)?RETURN?RAW;如：select?utl_raw.bit_and0f)?from?dual;select?utl_raw.bit_or0f)?from?dual;select?utl_raw.bit_xor0f)?from?dual;结果分别为1F344321、1D3443215、给指定字节赋值??FUNCTION?overlay(overlay_str?IN?RAW,?????????????????? target??????IN?RAW,?????????????????? pos?????????IN?BINARY_INTEGER?DEFAULT?1,?????????????????? len?????????IN?BINARY_INTEGER?DEFAULT?NULL,?????????????????? pad?????????IN?RAW????????????DEFAULT?NULL)?RETURN?RAW;如：select utl_raw.overlay(aa2,1) from dual;结果为：12AA43216、类型转换函数??FUNCTION?cast_to_raw(c?IN?VARCHAR2?CHARACTER?SET?ANY_CS)?RETURN?RAW;??FUNCTION?cast_to_varchar2(r?IN?RAW)?RETURN?VARCHAR2;??FUNCTION?cast_to_nvarchar2(r?IN?RAW)?RETURN?NVARCHAR2;??FUNCTION?cast_to_number(r?IN?RAW)?RETURN?NUMBER;??FUNCTION?cast_from_number(n?