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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 26 2002

Added on Jun 27 2002

#general-database-discussions

2 comments

433 views