Re: Oracle 10g Copy Blob

From: <mman37x_at_cs.com>
Date: 30 Aug 2006 10:12:51 -0700
Message-ID: <1156957971.557379.214950@h48g2000cwc.googlegroups.com>

Michel Cadot wrote:
> "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);

Is this new for 10G? This didn't work for BLOBs (or any binary fields) in previous versions. Received on Wed Aug 30 2006 - 12:12:51 CDT