Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!news.tele.dk!small.news.tele.dk!213.56.195.71!fr.usenet-edu.net!usenet-edu.net!fr.clara.net!heighliner.fr.clara.net!newsfeed.hanau.net!bnewspeer00.bru.ops.eu.uu.net!bnewsifeed00.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: <3cd530d1@news.uni-linz.ac.at> Subject: Re: BLOB, CLOB Date: Sun, 5 May 2002 16:19:05 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 29 Message-ID: <3cd54d6c$0$8511$cc9e4d1f@news.dial.pipex.com> NNTP-Posting-Host: userck09.uk.uudial.com X-Trace: 1020611949 news.dial.pipex.com 8511 62.188.154.51 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.server:145954 X-Received-Date: Sun, 05 May 2002 08:17:39 MST (news.easynews.com) look into dbms_lob which will allow you to do this . -- Niall Litchfield Oracle DBA Audit Commission UK "Simon Walchshofer" wrote in message news:3cd530d1@news.uni-linz.ac.at... > 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 > >