I have an app that works with different databases (SQL Server, ASE, SQL Anywhere, Oracle) and one of the tables has an blob column.
I have a need to duplicate a bunch of rows in the table. What would the best way of duplicating the blob data be?
Do I need to loop through all the rows individually like this:
select the normal columns
selectblob the blob column
insert the normal columns
updateblob the blob column
Or is there a simpler way? It must be generic enough to work on different database types.