oracle执行update语句字段更新内容过长380玩彩网官网入口的解决方案ora-380玩彩网官网入口

错误描述：ora-00972：标识符过长

错误原因：update的字段使用了双引号

对于超长的存储sql举例

update feature set "feature_sql" = 'select sum(case when bglst_typ_cd in (''01'', ''02'', ''03'', ''04'', ''11'', ''12'') then 1 else 0 end) val from bds_rtafp_inadb_lnact_nmlst t inner join risk_request r on r.risk_request_id = t.risk_request_id where r.risk_request_individual_id = ''{individualid}'' and r.risk_request_status = ''finish''' where code = 'black_list'

oracle有个不好的地方，就是更新内容内包含单引号的，需要使用双单引号反转义一下，即可直接更新
错误案例

update feature set "feature_sql" = "select sum(case when bglst_typ_cd in ('01', '02', '03') then 1 else 0 end) val from bds_rtafp_inadb_lnact_nmlst t inner join risk_request r on r.risk_request_id = t.risk_request_id where r.risk_request_individual_id = '{individualid}' and r.risk_request_status = finish'" where code = 'black_list'

我们使用了双引号更新，会直接抛出标识符过长错误

本作品采用《cc 协议》，转载必须注明作者和本文链接