XMLType problem

Hi everyone,

Under oracle 9.2i if you execute this:

select xmltype('<tag>It''s
cool</tag>').extract('//tag/text()').GetStringVal() from dual;

you get: It&apos;s cool

The question is simple: How to get --> It's cool ????

Thanks in advance for any response. Received on Wed Apr 07 2004 - 11:50:01 CDT