oracle字段替换 REPLACE(prop_value,'藏区','西藏地区')

oracle字段替换 REPLACE(prop_value,'藏区','西藏地区')   将数据库字段prop_value中的藏区替换为西藏地区

 UPDATE  PROD_PRODUCT_PROP set prop_value=REPLACE(prop_value,'藏区','西藏地区') where PRODUCT_id in (183240,183514,841457,424704,568583,600632,248634,248526,741929,256912,250529,250527,250445,250750,250797,250891,252074,252439,253604,253076,253107,252115,253383,256641,255133,252601,252800,255084,257019,250156,250524,250526,256011,50734,250735,250892,575058,1536434,2609593,2608667
) and prop_id =305

posted @ 2021-01-18 19:43  wyuioahxvm  阅读(185)  评论(0编辑  收藏  举报