Re: Something to ponder ..

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 26 Jan 2000 17:40:23 +0100
Message-ID: <86n81n$v7b$1@news5.isdnet.net>

May be you would do:
v734> SELECT RAWTOHEX(HEXTORAW('1234')) from dual;

RAWT

1234

What you made is to translate the hexadecimal value of the string '1234' that is 0x31323334 to the string '31323334' and then back to a raw that is implicitly converted to the string '31323334' by the select to display the value.

--
Have a nice day
Michel

Paul Baker <paul.baker_at_lvs.co.uk> a écrit dans le message : 86mmfp$j9a$1_at_soap.pipex.net...
> Can anyone explain the following?
>
> SQLWKS> SELECT HEXTORAW(RAWTOHEX('1234')) from dual;
>
> HEXTORAW
> --------
> 31323334
> 1 row selected.
>
> I would expect 1234 to be returned .. am I being stupid?
>
>
Received on Wed Jan 26 2000 - 10:40:23 CST