Re: Manipulating field of RAW datatype

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 4 Nov 1999 15:55:48 +0100
Message-ID: <7vs6s9$mal$1@oceanite.cybercable.fr>

There is the HEXTORAW function that converts a string containing hexadecimal digits to raw value.

update poop set rawfield=hextoraw('1234');

this statement updates your row field with 2 bytes: 0x12 and 0x34.

--
Have a nice day
Michel

Sundar Raman <cybertoast_at_mindless.com> a écrit dans le message : 38218FC2.9CCAEC1D_at_nopoop.mindless.com...
> I hope this is a simple question - I've got a table that has a field of
> type RAW. I'd like to set the value to something in particular, but I
> can't find the function/procedure to do this. I'm using OCI. I'd
> prefer to have a SQL solution, meaning some function that works in SQL
> to do the translation of my data to the format that RAW expects, for
> example:
>
> update poop
> set rawfield = converttoraw(1234);
>
> where converttoraw is the magic solution to get the data into the field.
>
> Thanks a lot for all help. Cheers.
>
Received on Thu Nov 04 1999 - 08:55:48 CST