Re: copy varchar to CLOB
Dominic Soh wrote:
>
> Hi,
> I got a table with varchar as one of the column. Due to the
> short length, I am trying to change the varchar column to
> CLOB. I like to copy the data from the existing table
> to the new table. How can I copy the varchar over
> to be CLOB? Any help will be appreciated. Thanks.
You should just be able to:
INSERT INTO table2 SELECT * FROM table1;
Art S. Kagel