Friday, 17 April 2015

Combination of replace and regexp_replace


The Combination of using replace and regexp_replace

SELECT    
         clause CLAUSE, regexp_replace(REPLACE(replace(replace(replace(replace(replace(tc_description,'<br>',chr(10)),'<br/>',chr(10)),'<br />',chr(10)),
          '</br>',chr(10)),'</ br>',chr(10)),'P_OP_MARGIN',NVL(:CP_OPERATING_MARGIN,'8')),'&', '\&'||'amp;') TC_DESCRIPTION
         FROM
         BRITANNIA_TERM_CONDTION_MSTR NTCM
         ,britannia_term_clause_mstr  NTCLM
         WHERE
         NTCM.status                 = 1
         AND NTCLM.status            = 1
         AND TC_TYPE                 = 15
         AND TC_NAME = 127
           AND NTCM.term_condition_id  = NTCLM.TERM_CONDITION_ID
         ORDER BY CLAUSE;

No comments:

Post a Comment

Uploading PO Attachments from EBS to FTP Server

 create or replace PROCEDURE xx_upload_po_attachment(errbuff out varchar2, retcode out number)  IS CURSOR cur_new_attmt IS    select ponumbe...