oracle更新clob类型字段内容

DECLARE  
  clobValue tablename.content%TYPE;  
BEGIN  
  clobValue := 'long text content';
  UPDATE tablename  SET content = clobValue  WHERE ID = 'ID';
  COMMIT;  
END;

 

posted @ 2021-06-01 14:46  DemLiu  阅读(891)  评论(0编辑  收藏  举报