SQL statement for changing the varchar2 field (with data) of a table to the clob Field

Create Table yn_test_clob (ID int, bb_1 varchar2 (255 ))

Insert into yn_test_clob values (1, 'iihero ')

Select * From yn_test_clob

Alter table yn_test_clob rename column bb_1 to bbb_1

Select * From yn_test_clob

Alter table yn_test_clob add bb_1 clob

Update yn_test_clob set bb_1 = bbb_1

Select * From yn_test_clob

Alter table yn_test_clob drop column bbb_1

Select * From yn_test_clob

 

Reference: how to change the varchar2 field to a clob field in Oracle

Http://topic.csdn.net/u/20070620/14/1084030e-eccc-49f4-a484-574c07f176a8.html

How to modify the table name http://www.itpub.net/thread-242741-1-1.html with SQL

Http://www.iteye.com/problems/23956 for clob processing large string problems in Java