DevOps, CI/CD and Automation

Dear all,

i am reading an xmltype column from a table and storing the value of the same in a Varchar2. i am using the below query.

SELECT RECID , E.XMLRECORD.GETCLOBVAL () AS POXML FROM MY_TABLE E;

Result
-----------
'MINOR&apos

the issue is when reading the data all the special character is changed for example single quotes ' display as &apos and & display as &amp.

i do not want this to happen i need the value as it is.

Result Expected

------------------

'MINOR'

need to know how to do this asap.

Thanks & Regards