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