BLOB, CLOB

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 - 08:18:32 CDT