Updating clob column
But it does not change anything in the clob field of oracle.
Example: Writing CLOB Data Use the set Character Stream method or the set Ascii Stream method to write data to a CLOB.
elwarren is obviously wise in the ways of Perl and Oracle ;-) I could be wrong, but I think you're talking about the oracle "long" datatype.
You can manipulate "long" columns by using placeholders and bind values. Seriously, you're going to need to be a little more comprehensible. And, if I understand you correctly (which there is a good chance I might not), you're asking us to do work for you.
I have more than 100, 000 of records in this table.