select DISTINCT exttext10 from BO_ACT_DICT_KV_ITEM
WHERE DICTKEY = 'NPD.PROJECT.MANUSITE'
AND instr(','||'1140,1160,1120'||',', ','||ITEMNO||',')>0
and isactive=1 and exttext6='生产型' and exttext1=''|| '22000022' ||'' and exttext2='0'
上面的语句是可以再数据库正确执行的,现在我想通过rowtocol语句,求怎么写,
select ROWTOCOL('select DISTINCT exttext10 from BO_ACT_DICT_KV_ITEM
WHERE DICTKEY = ''NPD.PROJECT.MANUSITE''
AND instr('','||'(1140,1160,1120)'||','', '','||'ITEMNO'||','')>0
and isactive=1 and exttext6=''生产型'' and exttext1='''|| '22000022' ||''' and exttext2=''0''', ' ') from dual
这是我试着写的,但是一直报错,也不知道如何修改,求大神指点
如何把下面这句话转义成正确的写法
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-