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