Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help - RAW literals
A copy of this was sent to "James A. Littlefield" <jal_at_alum.mit.edu>
(if that email address didn't require changing)
On Mon, 14 Jun 1999 14:28:37 -0400, you wrote:
>My application needs to store binary data in RAW columns. In MSSQL7.0
>I could initialize these column values specifying a literal value
>"0x010203040506" as part of the SQL insert statement. This doesn't
>work under Ora8.0.5? If I have a RAW(6) column, what is the correct
>SQL syntax for setting its value?
>
>Thanks
>Jim
>
hextoraw( '010203040506' );
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/
Current article is "Fine Grained Access Control", added June 8'th
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA--