Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert long column to char

299532Jun 27 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2002
Added on Jun 27 2002
2 comments
433 views