Re: Oracle 10g Copy Blob

"Aimyee" <gaz1972_at_gmail.com> a écrit dans le message de news: 1156955498.018755.287530_at_h48g2000cwc.googlegroups.com...
|I have a blob column A in table T1 I Need to move this column to column
| B in table T2.
|
| I need to do this for about 500,000 records.
|
| CAN I do this via PL/SQL?
|
| Thank in advance!!
|

For instance:

insert into T2 (B) select A from T1;
update T2 set b=(select a from T1 where t1.id = t2.id);

Regards
Michel Cadot Received on Wed Aug 30 2006 - 12:02:09 CDT