Change Column from Varchar2 to CLOB


SQL>alter table test_table add clob_column CLOB;

Table altered.

SQL> update test_table set clob_column = current_varchar_column;

xx rows updated.

SQL> alter table test_table drop column current_varchar_column;

Table altered.

SQL> alter table test_table rename column clob_column to current_varchar_column;

Table altered.


Java4iPhone

Product Intro - List2Shop - Manage your shopping checklist!

Did you ever wish, you had a shopping checklist handy every time you went to a grocery store or a mall? Ever thought of a tool to keep a tab on weekly shopping needs?

Refer:

http://www.list2shop.com/shopping/