select substr(replace(str,'"',''),1,instr(replace(str,'"',''),',',1,2)-1)||
substr(replace(str,'"',''),instr(replace(str,'"',''),',',1,2)+1) newstr from tbname;//str为包含此字符串的列名
substr(replace(str,'"',''),instr(replace(str,'"',''),',',1,2)+1) newstr from tbname;//str为包含此字符串的列名
----------------------------------------------------
2222
0,,1130','"',''),',',1,2)-1)||
2 substr(replace('111,"2,222",R00,2000,,1130','"',''),instr(replace('111,"2,222",R00,2000,,1130',
'"',''),',',1,2)+1) newstr from dual;NEWSTR
-----------------------
111,2222,R00,2000,,1130SQL>
bzszp(SongZip) 兄,字符串中不定有"2,222"这样的字符,怎样能只找第二个为逗号的替代呢"2,222"这种形式的个数在该字符串中不定?
楼主请解释