select 'update t_dw_jbxx set pcsdm= ''' || temp.pcsdm ||''' where dwdm= ''' || temp.dwdm || ''';' as updatesql from (select pcsdm, dwdm from t_dw_jbxx where pcsdm like '99%') temp
oracle 转义双引号
最新推荐文章于 2024-07-01 11:18:54 发布
select 'update t_dw_jbxx set pcsdm= ''' || temp.pcsdm ||''' where dwdm= ''' || temp.dwdm || ''';' as updatesql from (select pcsdm, dwdm from t_dw_jbxx where pcsdm like '99%') temp