XML CDATA Extents, special characters: <= less than equals, >= greater than equal

The XML document contains text similar to "Elements looks like <this>", where "<this>" interprets the parser as an element, and what people actually want is the literal text that "<this>" represents.

1.CDATA Zone: It's all called character data, to "<![ Cdata[ "begins with the" ]]>"End, embedding the original data between the two that does not want to be parsed by the parser, and the parser does not parse the content in the CDATA area, but

Leave this data intact to the downstream process.

2. Special characters:

In XML: <= is less than or equal, >= is greater than or equal to the markup that you want to add: <![ cdata[]]> XML has a & symbol that requires <! [cdata[&]]> This means &

<= is less than or equal to: <! [Cdata[<=]]>

>= is greater than or equal to: <! [Cdata[>=]]>

Some special characters can also be replaced by the following substitution symbol.

Special character substitution symbol

& &amp;

< &lt;

> &gt;

"&quot;

' &apos;

eg.

<!--drilling daily use SQL-->
<entry key= "Zjdailydrillrepcnquery" >
<map>
<entry key= "SQL" >
<value>
Select Zjdailydrillrep.dailydrilrepid,
ZJDAILYDRILLREP.WELLBORE_ID,
Bore.well_legal_name,
Zjdailydrillrep.spudin_date,
Zjdailydrillrep.reportfor,
ZJDAILYDRILLREP.DEPTHMKB,
ZJDAILYDRILLREP.TVDMKB,
ZJDAILYDRILLREP.FORMAT_ID,
Zjdailydrillrep.enginbrief,
Zjdailydrillrep.dailywellcost,
Zjdailydrillrep.insert_date,
Zjdailydrillrep.status,
Zjdailydrillrep.comments,
Zjdailydrillrep.submitter,
Zjdailydrillrep.verifyer,
Rig.rig_no,
Zjdailydrillrep.rothours,
(select GEO.) Current_td
From Lj_daily_geological_report GEO
where zjdailydrillrep.wellbore_id = GEO. wellbore_id
and GEO. Report_date = Zjdailydrillrep.reportfor
and geo.half_full = ' 260002 ' and rownum<! [Cdata[<=1]]>TD,--------Express RowNum <=1

(select GEO.) Current_td
From Lj_daily_geological_report GEO
where zjdailydrillrep.wellbore_id = GEO. wellbore_id
and GEO. Report_date = Zjdailydrillrep.reportfor-1
and geo.half_full = ' 260002 ' and rownum<! [Cdata[<=1]]>) Tdbefore
From Zj_dailydrillrep Zjdailydrillrep
Left Join Comm_wellbore Bore
On bore.wellbore_id = zjdailydrillrep.wellbore_id
Left JOIN Zj_rig_data Rig
On rig.rig_id = bore.rig_id
where 1 = 1

</value>
</entry>
</map>
</entry>