高分！！！！很急的问题,希望大家帮帮忙！！！

Question

select substr(replace(str,'"',''),1,instr(replace(str,'"',''),',',1,2)-1)||
substr(replace(str,'"',''),instr(replace(str,'"',''),',',1,2)+1) newstr from tbname;//str为包含此字符串的列名

Answer 1

SQL> select to_number(replace(replace('"2,222"','"',''),',','')) from dual;TO_NUMBER(REPLACE(REPLACE('"2,222"','"',''),',',''))
----------------------------------------------------
                                                2222

Answer 2

把你对应的列替换! to_number(replace(replace(col,'"',''),',',''))

Answer 3

SQL> select substr(replace('111,"2,222",R00,2000,,1130','"',''),1,instr(replace('111,"2,222",R00,200
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>

Answer 4

sorry,理解错误!
bzszp(SongZip) 兄，字符串中不定有"2,222"这样的字符，怎样能只找第二个为逗号的替代呢"2,222"这种形式的个数在该字符串中不定？
楼主请解释