INSERT Binary Data

#1

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

#2

"Peter Plumber" <Klempner (AT) gmxdot (DOT) net> wrote

Quote:

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

search for blob / bfile on tahiti.oracle.com

#3

Peter Plumber wrote:

Quote:

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@x.washington.edu
(replace 'x' with 'u' to respond)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

INSERT Binary Data

comp.databases.oracle.server comp.databases.oracle.server

INSERT Binary Data - 10-03-2004 , 05:00 AM

Re: INSERT Binary Data - 10-03-2004 , 05:07 AM

Re: INSERT Binary Data - 10-03-2004 , 11:40 PM