Question: how to copy blob data from one table to another in oracle?
Answer: SYS@TCDB1 > create table source (id int, val int); Table created. SYS@TCDB1 > create table dest (id int, val int); Table created. SYS@TCDB1 > insert into source values (1,1); 1 row created. SYS@TCDB1 > insert into source values(2,2);