Long raw to blob

[DontBShy]

Hi,

I need to import a long raw column from a table to another table in a blob field. How can I do that? How use select with long dadatype?

Thanks

[jamoji]

You can import the data like this

Insert into table (blob_value)
select to_lob(long_value) from table2;

The long raw data will be converted automatically into blob,and long data will be converted into Clob...

Regards