You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!