How to convert long column to char
Would you please suggest on how can I load a data from a long column into a varchar2 column.
We have a table that have erroneously set up to have a long column. We would like to take the character data from this column and place it in another column in this table.
update table_foo set column_varchar = column_long doesn't work. Neither does:
update table_foo set column_varchar = to_char(column_long)
I would appreciate any suggestions.
Thanks,
Boris.
Oracle version 8.1.6