Re: Hex to Dec

Hi,

Did you try dump function?

SVRMGR> select rawtohex(a) from test_tab; RAWTOHEX(A)

• AAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBBBBBBBBBB CCCCCCCCCCCCCCCCCCCC 3 rows selected. SVRMGR> select dump(a) from test_tab; DUMP(A)

  ---

• Typ=23 Len=10: 170,170,170,170,170,170,170,170,170,170 Typ=23 Len=10: 187,187,187,187,187,187,187,187,187,187 Typ=23 Len=10: 204,204,204,204,204,204,204,204,204,204 3 rows selected.

Andrew Protasov

In article <79u6if$5i_at_romeo.logica.co.uk>,   "Jeroen van der Goorbergh" <GoorberghJ_at_Logica.com> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Feb 13 1999 - 18:47:42 CST