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

Home -> Community -> Usenet -> c.d.o.server -> Re: casting into hex?

Re: casting into hex?

From: Candido Dessanti <candido.dessanti_at_blunet.it>
Date: 6 Feb 2003 02:30:28 -0800
Message-ID: <11c1e2d8.0302060230.21e71c2c@posting.google.com>


"Aakash Bordia" <a_bordia_at_hotmail.com> wrote in message news:<b1rnhc$g3i$1_at_hanover.torolab.ibm.com>...
> Hello, How can I cast a string like 'abc' to hex and insert it into a raw
> column.
>
> eg: insert into table1 select raw(hex('abc')) from table2
>
> How do I accomplish this in SQL ?

insert into table1
select rawtohex(youtextfield) from table2; Received on Thu Feb 06 2003 - 04:30:28 CST

Original text of this message

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