对于oracle数据库中CLOB数据类型的修改

对于ORACLE中CLOB数据操作

clob是oracle对于比较大的数据的操作，像mysql的longText，clob可以对4g数据进行操作。而普通的insert根本不能插入到表中需要存储过程才可

DECLARE
clobValue 表名.字段名%TYPE;
BEGIN
clobValue := 'XXX'; --字段内容
UPDATE 表名 T SET T.字段名 = clobValue WHERE 条件;
COMMIT;
END;

具体的项目例子：DECLARE
clobValue EB_DESIGN_ARTICLE.ARTICLE_CONTENT%TYPE;
BEGIN
clobValue := '<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">山东供销e家《樱桃</span></span> <span style=\"font-size:16pt\"><span style=\"font-family:仿宋\">季</span></span> <span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">》专题活动，帮助对接外省形成批量交易，另外统合零售端向全省零售推广，面向线下山东各地樱桃产地商户现开始招商。商户参与供应形式可分为B2C零售（通过pc端、微信）、渠道批发两种形式。</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><span style=\"font-size:16pt\"><span style=\"font-family:仿宋\"><strong>一、时间节点</strong></span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\">   <span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">商户报名时间：2017年4月27到5月12</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\">   <span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">活动开场时间：2017年5月15日</span></span></span></span></span></span></p>\n\n<p style=\"margin-left:0cm; margin-right:0px; text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><span style=\"font-size:15pt\"><span style=\"font-family:仿宋\"><strong>二、</strong> </span></span><span style=\"font-size:15pt\"><span style=\"font-family:仿宋\"><strong>商户参与供应形式及联系人</strong></span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><strong>  </strong><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">1.</span></span> <span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">商户参与供应形式：</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><strong>    </strong><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">B2C</span></span> <span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">零售<strong>，</strong>采用推单模式，以统合B2C零售商户进行导流。</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">联系人：陈一明</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">联系电话：18653140202</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">邮箱： <a href=\"mailto:chenyiming@sdgxyj.com\"><strong>chenyiming@sdgxyj.com</strong></a></span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><strong>  </strong><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">2.</span></span> <span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">商户参与供应形式：</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><strong>   </strong><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">渠道批发，采用省外推介模式，以产地组团对接省外大宗交易。</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><strong>   </strong><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">联系人：陈  潜</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\">   <span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">联系电话：18888371130</span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\">   <span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">邮箱： <a href=\"mailto:chenqian@sdgxyj.com\"><strong>chenqian@sdgxyj.com</strong></a></span></span></span></span></span></span></p>\n\n<p style=\"text-align:left\"><span style=\"font-size:16px\"><span style=\"color:#666666\"><span style=\"font-family:微软雅黑,\"><span style=\"background-color:#ffffff\"><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\"> <strong>  </strong></span></span><span style=\"font-size:14pt\"><span style=\"font-family:仿宋\">请商户及时关注参与活动，报名请咨询对应联系人确定对接供应形式和货运形式。</span></span></span></span></span></span></p>\n'; --字段内容
UPDATE EB_DESIGN_ARTICLE T SET T.ARTICLE_CONTENT = clobValue
WHERE T.ARTICLE_ID = 'lzn1xsgldwewa81soi6';
COMMIT;
END;