utl_raw.cast_to_number : utl_raw « System Packages « Oracle PL / SQL






utl_raw.cast_to_number

 
SQL>
SQL>  select utl_raw.cast_to_number( 'c202182e' ) from dual;
UTL_RAW.CAST_TO_NUMBER('C202182E')
----------------------------------
                            123.45

1 row selected.

SQL> --

 








Related examples in the same category

1.utl_raw.concat( '9', '0102', 'ff', '0a2b' )
2.utl_raw.cast_to_raw( 'Cameron' )
3.utl_raw.cast_to_raw
4.utl_raw.cast_to_varchar2( '43616D65726F6E')
5.utl_raw.length( '43616D65726F6E')
6.utl_raw.substr( '0102030405', 3, 2 )
7.utl_raw.translate( '0102030405', '0203', '06' )
8.utl_raw.transliterate( '010203040502', '0809', '01020304', '0a' )
9.utl_raw.overlay( 'aabb', '010203' )
10.utl_raw.overlay( 'aabb', '010203', 2 )
11.utl_raw.overlay( 'aabb', '010203', 5 )
12.utl_raw.overlay( 'aabb', '010203', 2, 1 )
13.utl_raw.overlay( 'aabb', '010203', 5, 1, 'FF' )
14.utl_raw.copies( '010203', 4 )
15.utl_raw.xrange( '01', '11' )
16.utl_raw.xrange( 'fa', '06' )
17.utl_raw.reverse( '0102030405' )
18.utl_raw.compare( '010203', '01020304', '04' )
19.utl_raw.compare( '01050304', '01020304' )
20.utl_raw.bit_and
21.utl_raw.bit_or
22.utl_raw.bit_xor
23.utl_raw.bit_complement
24.utl_raw.cast_from_number
25.utl_raw.cast_from_binary_integer
26.utl_raw.cast_to_binary_integer