Re: select LONG RAW column into BLOB column?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 10 Mar 2006 23:02:54 +0100
Message-ID: <dust1v$dnr$01$1@news.t-online.com>

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 Received on Fri Mar 10 2006 - 16:02:54 CST