Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! Hex to Dec???

Re: Help! Hex to Dec???

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Fri, 12 Feb 1999 00:19:49 +0000
Message-ID: <36C373A5.495C7A96@rdbms.freeserve.co.uk>


Jeroen,

What about using RAWTOHEX, then you can use apply any byte swapping, sign correction depending on the type of binary data ie signed long, unsigned long etc.

Chris

Jeroen van der Goorbergh wrote:
>
> Hi,
>
> I've got the following, rather simple, problem: I've got a column (RAW)
> filled with binairy data (MS byte ordering) and I want to convert the data
> to decimal values. I presumed Oracle would have a simple function for this
> and but having extensively searched through the documentation I still
> haven't found a simple solution. Am I overlooking something or do I have to
> write the procedure myself?
>
> Thanks in advance,
>
> Jeroen van der Goorbergh
Received on Thu Feb 11 1999 - 18:19:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US