Really nice to be able to create ~ and -~. For years I was keeping a copy of the numbers, copied from ixora (http://www.ixora.com.au/notes/infinity.htm)
Now we can just use UTL_RAW.CAST_TO_NUMBER( ‘FF65′ ) and UTL_RAW.CAST_TO_NUMBER( ’00’ ) !
But I am quite unhappy of the following:
SELECT UTL_RAW.CAST_TO_NUMBER( ‘FF65′ ) – UTL_RAW.CAST_TO_NUMBER( ‘FF65′ ) FROM dual;
(Funny enough, the same with ’00’ instead of ‘FF65′ gives the ORA-01426)