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: Something to ponder ..

Re: Something to ponder ..

From: Piotr Kalandyk <Piotr.Kalandyk_at_comarch.pl>
Date: Wed, 09 Feb 2000 08:24:33 GMT
Message-ID: <388EFFC0.458F6141@comarch.pl>


Try SELECT hextoraw(rawtohex(hextoraw('1234'))) from dual; Subtype CHAR and ROW are not the same.

Paul Baker wrote:

> 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 Feb 09 2000 - 02:24:33 CST

Original text of this message

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