René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

utl_raw

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
);