Wednesday, 15 April 2015

How to replace & with & amp; in oracle


I have a requirement to display the text in HTML Output. In the item description I was encountering an issue with &, whenever this symbol is present the concurrent program is completing with Warning.

To overcome this issue, we need to change the & symbol with &

Solution:-

select regexp_replace(tc_description,'&', '\&'||'amp;') from xx_table;

The output of the query without replacing the description is:
Installation & Training (Small Library)

Now after changing the query, the output is

Installation & Training (Small Library).


For my requirement the above query has given the result. 

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...