oracle 中update select 和连接字符串配合使用

update SYS_MDL_DIMSET_ACXMModel b
set f_Srccont =
(select SYS_MDL_DIMSET.f_Srccont || 'useInnrDataSet=0;'
from sinojzxm.SYS_MDL_DIMSET_ACXMModel a
where a.rowid = b.rowid)
where cst_id = 'ZYXMYE0000002'

posted @ 2017-02-07 16:13  zzdxw  阅读(846)  评论(0编辑  收藏  举报