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