Re: Oracle 10g Copy Blob


<mman37x@xxxxxx> a écrit dans le message de news: 1156957971.557379.214950@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Michel Cadot wrote:
"Aimyee" <gaz1972@xxxxxxxxx> a écrit dans le message de news: 1156955498.018755.287530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|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


.

Relevant Pages

  • Re: Serving PDF files with SQL through firewall to ASP.Net
    ... expose PDF reports. ... I don't recommend putting BLOBs in the database but a link to the BLOB ... strings through a designated SQL port to ... > I want to be able to expose PDF files with the SQL Server that's on this ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Frage zu binären Daten im SQL 2005 speichern
    ... "To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem?" ... 1000 Pdfs in einem Ordner habe, ... Vor allem aber sind BLOB Daten im SQL ... Server in Blöcken organisiert, wie Du u. a.: ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Frage zu binären Daten im SQL 2005 speichern
    ... "To BLOB or Not To BLOB: Large Object Storage in a Database or a ... 1000 Pdfs in einem Ordner habe, ... Vor allem aber sind BLOB Daten im SQL ... Server in Blöcken organisiert, wie Du u. a.: ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Escaping large chunk of text for insertion into mysql
    ... > field in mysql. ... Your SQL should be: ... > mentioned blob above). ... When you call executewith the proper parameters, ...
    (perl.beginners)
  • Load Sql Text or Image to Oracle LOB
    ... Is it possible to use DTS to import from sql to Oracle? ... Text to CLOB? ... Image to BLOB? ...
    (microsoft.public.sqlserver.dts)