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: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Wed, 5 Feb 2003 16:42:31 -0800
Message-ID: <b1sb68$15u$1@hanover.torolab.ibm.com>


how about strings like "aakash" instead of "abc". That does not work. Thats why my question of how to go from char to hex? Thanks

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:40134vk7287tltlabel4k1dletprjnfis5_at_4ax.com...
> On Wed, 5 Feb 2003 11:07:10 -0800, "Aakash Bordia"
> <a_bordia_at_hotmail.com> wrote:
>
> >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 ?
> >
> >I cannot use procedural SQL here.
> >Thanks
> >Aakash
> >
>
> The functions are rawtohex and hextoraw
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Feb 05 2003 - 18:42:31 CST

Original text of this message

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