to reload with sqlldr.
HTH
Jared
Mark Richard [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/08/2003 08:09 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Populating BLOB's from a SQL Script? - Solution
Ok, I got no suggestions but have found a rather clunky way to achieve
this:
Assuming a blob exists in a table somewhere then a statement like select
dbms_lob.substr(data, 1000, 1) from table can be used to retrieve 1000
bytes worth of data as hex.
For a new field a simple insert into table