通信通道的文件结束

oracle中表A的字段aa数据类型为CLOB

merge into A using (select '' bb from B) B on (A.id=B.id) when matched then  update set A.aa=B.bb

 --↑此处报错：通信通道的文件结束

merge into A using (select '' bb from B) B on (A.id=B.id) when matched then  update set A.aa=''

 --↑不报错

update A set aa=''

 --↑也不报错

merge into A using (select null bb from B) B on (A.id=B.id) when matched then  update set A.aa=B.bb

 --↑也不报错，【个人最推荐这个

posted @ 2013-05-16 14:10  Sun_rain_ice  阅读(289)  评论(0)  编辑  收藏  举报