Re: CLOB to VARCHAR2 -- (ver 9i)

On 18 Sep 2006 10:02:21 -0700, matt_at_mailinator.com wrote:

>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.
>

did you try? As far as I know it is possible.
>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.
>

Just assign it. Implicit conversion shouldn't be a problem.
>
>thanks,
>matt

--
Sybrand Bakker, Senior Oracle DBA