SQL & PL/SQL

with t as
  (select '"QZY170309001",2487,"UT",1,"JAJAJ02731","test data, is ,for reference, Nomorevalid..","K","Q"' as str
  from dual
  )
select regexp_replace(str, '("[^",]+),([^"]*")', '\1\2\3' ) from t ;

Hi,

   We have to remove all commas inside double quotes . I have tried above query . it is removing from only first position.

Please let me know how to remove all the comma values

Expected output:

"QZY170309001",2487,"UT",1,"JAJAJ02731","test data is for reference Nomorevalid..","K","Q"