Top "Xmlelement" questions

How to replace ' or any special character in when using XMLELEMENT Oracle

I have the below query. How to keep the apostrophe (') intact and not getting it replaced by &apos …

sql xml oracle replace xmlelement