Special Characters in BIP Report
Summary:
have requirement of replacing special characters coming in the description column of the BIP report with following:
Double quotes replace with '"'
need to display below statement
Example : Oracle"oracle
expectation : Oracle"oracle
CODE :
SELECT REPLACE(:Parameter,'"','"') from dual
Above code is not working its showing same as " as passed in parameter.
If anyone tried this type of SQL code please send me the solution. Thanks in Advance
Tagged:
0