SQL & PL/SQL

hi there,

i  want to remove all the commas between double quotes:

I tried below pattern , but it does not replace all  if we have more than one comma in double quote.

SELECT REGEXP_REPLACE('123,"45,6",Hello ,"John , Mike , Marc", 456, ,"Anne-,Anna"','"([^"]*),([^"]*)"','"\1;\2"',1,0) as result

FROM DUAL;

Result

--------------------------------------------------------------------------

123,"45;6",Hello ,"John , Mike ; Marc", 456, ,"Anne-;Anna"

the first comma between "John , Mike ; Marc" is not replaced...