Hmmm....
SQL> CREATE TABLE xml_bin
2 (
3 xml_id NUMBER,
4 xml_doc SYS.XMLTYPE
5 )
6 XMLTYPE xml_doc STORE AS BINARY XML;
Table created.
SQL>
SQL> begin
2 INSERT INTO xml_bin (xml_id, xml_doc)
3 VALUES (1, xmltype (q'|<variable name="NL" select="'XX|' || CHR (38) || q'|#10;XX'" />|'));
4
5 INSERT INTO xml_bin (xml_id, xml_doc)
6 VALUES (2, xmltype (q'|<variable name="NL" select="'XX
7 XX'" />|' ));
8 end;
9 /
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT xml_id, xml_doc xml_doc FROM xml_bin;
XML_ID XML_DOC
---------- ----------------------------------------------------------------------------------------------------
1 <variable name="NL" select="'XX
XX'"/>
2 <variable name="NL" select="'XX XX'"/>
2 rows selected.
SQL>
SQL> CREATE TABLE xml_clob
2 (
3 xml_id NUMBER,
4 xml_doc SYS.XMLTYPE
5 )
6 XMLTYPE xml_doc STORE AS CLOB;
Table created.
SQL>
SQL> begin
2 INSERT INTO xml_clob (xml_id, xml_doc)
3 VALUES (1, xmltype (q'|<variable name="NL" select="'XX|' || CHR (38) || q'|#10;XX'" />|'));
4
5 INSERT INTO xml_clob (xml_id, xml_doc)
6 VALUES (2, xmltype (q'|<variable name="NL" select="'XX
7 XX'" />|' ));
8 end;
9 /
PL/SQL procedure successfully completed.
SQL>
SQL> SELECT xml_id, xml_doc xml_doc FROM xml_clob;
XML_ID XML_DOC
---------- ----------------------------------------------------------------------------------------------------
1 <variable name="NL" select="'XX
XX'"/>
2 <variable name="NL" select="'XX XX'"/>
2 rows selected.