CLOB to VARCHAR2 -- (ver 9i)

From: <matt_at_mailinator.com>
Date: 18 Sep 2006 10:02:21 -0700
Message-ID: <1158598941.877562.58900@m7g2000cwm.googlegroups.com>

hello,

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.

thanks,
matt Received on Mon Sep 18 2006 - 12:02:21 CDT