Re: select LONG RAW column into BLOB column?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 13 Mar 2006 02:20:04 GMT
Message-Id: <pan.2006.03.13.02.20.01.385523@sbcglobal.net>

On Fri, 10 Mar 2006 14:20:02 -0800, Joe Weinstein wrote:

> 
> 
> 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

If you need some discussion, here is a pointer to an exotic and infrequently used website:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:510622111991

You can get to it easily by entering "convert LOB" into "Page contains" field in the advanced search.

-- 
http://www.mgogala.com

Received on Sun Mar 12 2006 - 20:20:04 CST