PROSAGA码农传奇-plsql-Regex_replace仅检查1个实例

<div class =“post-text”itemprop =“text”>
  
    像这样的东西：
  
   <pre>
 <code>
 with t as (
 select 'STRING"' as s from dual union all
 select '"STRING' from dual union all
 select 'STRI"NG' from dual union all
 select 'STRING""' from dual union all
 select '"STRING"' from dual union all
 select 'STRING' from dual union all
 select '"STR"ING"' from dual union all
 select '"' from dual union all
 select '""' from dual union all
 select '"""' from dual
)
select
 s,
 regexp_replace(s,'^([^"]*)"([^"]*)$', '\1""\2') new_s
from t

</code>
 </pre>
  
    的
      说明：
    </强>
  
   <pre>
 <code>
 ^ # asserts position at start of a line
( # 1st capturing group
 [^"]* # matches characters that are not the character ", zero or more times
)
" # matches the character " literally
( # 2nd capturing group
 [^"]*
)
$ # asserts position at the end of a line

</code>
 </pre>
  
    在线查看
    <a href="https://rextester.com/ARYUJ38257" rel="nofollow noreferrer">
      rextester
    </A>
    。
  
</DIV>