Re: INSERT Binary Data

Peter Plumber wrote:

> Hi,
>
> I would like to INSERT Byte-Data INTO a BLOB-Field using SQL
>
> This is how it works for SQL-Server:
>
> INSERT INTO tblSlime ( ID, Name, Slime )
> VALUES (2, 'Fritz', 0x234323432343234323fc4350fc4350fc4350fc4350fc);
>
> Is something like this possible for ORACLE
>
> Thx,
>
> Peter

There are numerous ways to do it and numerous data types that can be used to store it. Here are a few refs:

http://www.psoug.org
click on Morgan's library
click on Data Types
also click on DBMS_LOB
also click on Conversion Functions

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)