From: "Simon Walchshofer" <simon.walchshofer@students.uni-linz.ac.at>
Newsgroups: comp.databases.oracle.server
Subject: BLOB, CLOB
Date: Sun, 5 May 2002 15:18:32 +0200
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: async227.edvz.uni-linz.ac.at
Message-ID: <3cd530d1@news.uni-linz.ac.at>
X-Trace: 5 May 2002 15:17:05 +0100, async227.edvz.uni-linz.ac.at
Organization: Johannes Kepler Universitaet Linz
Path: news.easynews.com!easynews!news-xfer.siscom.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newscore.univie.ac.at!aconews-feed.univie.ac.at!news.uni-linz.ac.at!async227.edvz.uni-linz.ac.at
Xref: easynews comp.databases.oracle.server:145927
X-Received-Date: Sun, 05 May 2002 06:14:48 MST (news.easynews.com)

Hi!

Is it possible to insert for example a picture into a table with one
sql-insert statement?

e.g.
create table myLob (id number, picture clob);

insert into myLob values (1, ??????????);

Is there a possibility to specify the file-path directly in the
insert-statement??

THX
Simon