1

I have this query: 

select nm_strgp brand 
from co_strgp
where id_strgp_lv='2';

One value in this column is HOLLAND & BARRETT but i want to display it as HOLLAND & BARRETT in BI publisher. How can I achieve this?

Noel
  • 10,152
  • 30
  • 45
  • 67
saniya
  • 15
  • 5

1 Answers1

2

You can use DBMS_XMLGEN.CONVERT to unescape the special XMLcharacters.

SQL> select DBMS_XMLGEN.CONVERT('HOLLAND & BARRETT',1) from dual;

DBMS_XMLGEN.CONVERT('HOLLAND&BARRETT',1)
--------------------------------------------
HOLLAND & BARRETT
Noel
  • 10,152
  • 30
  • 45
  • 67