如何将VARCHAR型转成CLOB型？

Question

SQL> desc test
 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------
 ID                                                 NUMBER
 DESCRIPTION                                        VARCHAR2(20)
 DESC_CLOB                                          CLOBSQL> select * from test;        ID DESCRIPTION          DESC_CLOB
---------- -------------------- -------------------------------------
         1 aaaSQL> update test set desc_clob = description;1 row updated.SQL> select * from test;        ID DESCRIPTION          DESC_CLOB
---------- -------------------- -------------------------------------
         1 aaa                  aaa