CREATE TABLE STREAM
( PAYLOAD CLOB
);
INSERT
INTO stream VALUES
('<MC><RECORD><CODE>4995908</CODE><TITLE>Adrenocortical </TITLE><ROOT_CODE>380146</ROOT_CODE><MOD>229</MOD></RECORD><RECORD><CODE>69354563</CODE><TITLE> right</TITLE><ROOT_CODE>380146</ROOT_CODE><MOD>230</MOD></RECORD></MC><MT><RECORD><TYPE>LATERALITY</TYPE><TITLES>Laterality</TITLES><MOD><MODIFIER><MCS>69383650</MCS></MODIFIER></MOD></RECORD></MT>');
I WANT TO DELETE the XMLELEMENTS (<TITLE>Adrenocortical </TITLE> AND <TITLE> RIGHT< /TITLE>)
from the above row, could not convert into XMLTYPE also.