utl_raw is a package that can convert raw to varchar2 and
vice versa.
Procedures/Functions
bit_and
function bit_and returns raw
(
r1 in raw ,
r2 in raw
);
bit_complement
function bit_complement returns raw
(
r in raw
);
bit_or
function bit_or returns raw
(
r1 in raw ,
r2 in raw
);
bit_xor
function bit_xor returns raw
(
r1 in raw ,
r2 in raw
);
cast_from_binary_double
function cast_from_binary_double returns raw
(
n in binary_double ,
endianess in binary_integer default
);
cast_from_binary_float
function cast_from_binary_float returns raw
(
n in binary_float ,
endianess in binary_integer default
);
cast_from_binary_integer
function cast_from_binary_integer returns raw
(
n in binary_integer ,
endianess in binary_integer default
);
cast_from_number
function cast_from_number returns raw
(
n in number
);
cast_to_binary_double
function cast_to_binary_double returns binary_double
(
r in raw ,
endianess in binary_integer default
);
cast_to_binary_float
function cast_to_binary_float returns binary_float
(
r in raw ,
endianess in binary_integer default
);
cast_to_binary_integer
function cast_to_binary_integer returns binary_integer
(
r in raw ,
endianess in binary_integer default
);
cast_to_number
function cast_to_number returns number
(
r in raw
);
cast_to_nvarchar2
function cast_to_nvarchar2 returns nvarchar2
(
r in raw
);
cast_to_raw
function cast_to_raw returns raw
(
c in varchar2
);
cast_to_varchar2
function cast_to_varchar2 returns varchar2
(
r in raw
);
compare
function compare returns number
(
r1 in raw ,
r2 in raw ,
pad in raw default
);
concat
function concat returns raw
(
r1 in raw default,
r2 in raw default,
r3 in raw default,
r4 in raw default,
r5 in raw default,
r6 in raw default,
r7 in raw default,
r8 in raw default,
r9 in raw default,
r10 in raw default,
r11 in raw default,
r12 in raw default
);
convert
function convert returns raw
(
r in raw ,
to_charset in varchar2 ,
from_charset in varchar2
);
copies
function copies returns raw
(
r in raw ,
n in number
);
length
function length returns number
(
r in raw
);
overlay
function overlay returns raw
(
overlay_str in raw ,
target in raw ,
pos in binary_integer default,
len in binary_integer default,
pad in raw default
);
reverse
function reverse returns raw
(
r in raw
);
substr
function substr returns raw
(
r in raw ,
pos in binary_integer ,
len in binary_integer default
);
translate
function translate returns raw
(
r in raw ,
from_set in raw ,
to_set in raw
);
transliterate
function transliterate returns raw
(
r in raw ,
to_set in raw default,
from_set in raw default,
pad in raw default
);
xrange
function xrange returns raw
(
start_byte in raw default,
end_byte in raw default
);
|