title: How to use regexp_replace to replace a character in a string using the select statement?
body: <p>Following is my code</p>
  
  <pre><code>select (upper(fname)||' '||upper(mname)||' '||upper(lname)) as customer_name,
  (indv_corp_flag) as Customer_type,
  (regexp_replace(passport_no,'D','B')"regexp_replace") as passport_no, 
  (case when indv_corp_flag = 'C' then registration_no else null end) as registration_no,
  (case when indv_corp_flag = 'I' then marital_status else null end) as Marital_status
  from Nbfc_krishnan_m;
  </code></pre>
  
  <p>it gives error like</p>
  
  <pre><code>ORA-00907: missing right parenthesis
  00907. 00000 -  "missing right parenthesis"
  *Cause:    
  *Action:
  Error at Line: 91 Column: 38
  </code></pre>
  
  <p>But on operating individually it works like</p>
  
  <pre><code>select
  regexp_replace(passport_no,'S','d')"regexp_replace" 
  from nbfc_krishnan_m; 
  </code></pre>
  
  <p>is successfully executed.</p>