CLOB to VARCHAR2 -- (ver 9i)

Giganews Newsgroups
Subject: CLOB to VARCHAR2 -- (ver 9i)
Posted by:  ma…
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
not allowed.

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.