|Subject:||CLOB to VARCHAR2 -- (ver 9i)|
|Date:||18 Sep 2006|
i am trying to convert my table's CLOB column into a VARCHAR2(2000)
column. can anyone helpe me figure out how (im new to Oracle).
one cannot simply do an ALTER, because evidently the type conversion is
i read a suggestion to create a new VARCHAR2 column, and then copy the
CLOB column's data to it. that sounds reasonable. how do i do this? ive
created the new column, but im not certain how to copy the CLOB-column
data into it.