Re: Oracle 10g Copy Blob

<mman37x_at_cs.com> a écrit dans le message de news: 1156957971.557379.214950_at_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.

SQL> create table a (c blob);

Table created.

SQL> insert into a values ('aaaa');

1 row created.

SQL> create table b (c blob);

Table created.

SQL> insert into b select * from a;

1 row created.

SQL> update b set c=(select c from a);

1 row updated.

SQL> @v

Version Oracle : 9.2.0.6.0

Regards
Michel Cadot Received on Wed Aug 30 2006 - 12:17:52 CDT