Re: select LONG RAW column into BLOB column?

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Fri, 10 Mar 2006 14:20:02 -0800
Message-ID: <4411FB92.9050707@bea.com>

Maxim Demenko wrote:

> Joe Weinstein schrieb:
>

>> Hi all, and thanks in advance...
>> What's the clever way to create and populate a new
>> table from the contents of an old table, but converting
>> the LONG RAW columns in the old table to BLOB columns
>> in the new one? Ie: What is the conversion function
>> I could use to do:
>>
>> insert into mynewtable (select convert_to(BLOB, myLongCol) from 
>> myoldtable).
>>
>> thanks.
>> Joe
>>

>
> There is the function to_lob() which can do this conversion.
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions185.htm#i79464
>
>
> Best regards
>
> Maxim

Much thanks for the pointer.
Joe Received on Fri Mar 10 2006 - 16:20:02 CST