Subject Merging two textual blob fields
Author norgepaul

I am trying to figure out the best way to do the following:

I have a database with around 1.5 million records. One of the tables
has two BLOB fields that contain text. I would like to merge these
BLOB fields into a third BLOB field then remove the original fields.

Can this be done using only SQL or must I write a little program?

The program would be simple apart from the fact that I would have to
select 1.5 million records! What would be the best way to do this. I'm
thinking select the first 200 records, process them, commit the
transaction, move to the next 200, process them etc. Is this possible
using just the FIRST and SKIP commands? Is this the way a datapump
application would work?