oracle高手进为什么这样差不出值来,数据库中是有值的select wm_concat(decode(a,'01','aa',a)) from (select regexp_substr(t.gwys_1,'[^,]+',1,rownum) a,t.pk_dyccqsfjlb_id id from mchis.jdh_mcheck_first t connect by rownum

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/16 01:53:01
oracle高手进为什么这样差不出值来,数据库中是有值的select wm_concat(decode(a,'01','aa',a)) from (select regexp_substr(t.gwys_1,'[^,]+',1,rownum) a,t.pk_dyccqsfjlb_id id from mchis.jdh_mcheck_first t connect by rownum
xMKAvAsbDx]qv|ߗvW̛AR 0|)۩ЮH[0g~Ѣp=Y؝4v^JΨN.YkH=Ǫ# ŀU{>s.U[6 #YĪK98Uu${hㆩf0Y(AjAԲTxHdrq1-ͪ86)%z#b"&0Gċ`^(C}gs!-YZoNX6,Z3FN==׉CփGıiǍp7ck/\rWvZԾyJ$dhHQ}

oracle高手进为什么这样差不出值来,数据库中是有值的select wm_concat(decode(a,'01','aa',a)) from (select regexp_substr(t.gwys_1,'[^,]+',1,rownum) a,t.pk_dyccqsfjlb_id id from mchis.jdh_mcheck_first t connect by rownum
oracle高手进
为什么这样差不出值来,数据库中是有值的
select wm_concat(decode(a,'01','aa',a)) from (select regexp_substr(t.gwys_1,'[^,]+',1,rownum) a,t.pk_dyccqsfjlb_id id from mchis.jdh_mcheck_first t connect by rownum

oracle高手进为什么这样差不出值来,数据库中是有值的select wm_concat(decode(a,'01','aa',a)) from (select regexp_substr(t.gwys_1,'[^,]+',1,rownum) a,t.pk_dyccqsfjlb_id id from mchis.jdh_mcheck_first t connect by rownum
只是替换01变为aa,直接用replace不就行了完了:
select REPLACE(t.gwys_1,'01','aa') from mchis.jdh_mcheck_first t ;
你要这个语句到底干什么用?