select LONG RAW column into BLOB column?

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 Received on Fri Mar 10 2006 - 15:50:52 CST