Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: casting into hex?
"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