Re: Help - RAW literals

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 14 Jun 1999 20:45:03 GMT
Message-ID: <377469c3.31009449@newshost.us.oracle.com>

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

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 14 1999 - 15:45:03 CDT