look into dbms_lob which will allow you to do this .
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Simon Walchshofer" <simon.walchshofer_at_students.uni-linz.ac.at> wrote in
message news:3cd530d1_at_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
>
>
Received on Sun May 05 2002 - 10:19:05 CDT
