Re: casting into hex?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 05 Feb 2003 22:37:42 +0100
Message-ID: <40134vk7287tltlabel4k1dletprjnfis5@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 - 15:37:42 CST