XinYu_RZMES/.svn/pristine/1d/1dd3c32338baeca24ead04febb996185d462b5d9.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Project T">
	
	
	<query id="SyncL2WithL3.DeleteL2CoilComm.Delete" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
DELETE FROM TBH02_COIL_COMM2 A WHERE 1 = 1
        ]]>
    </query>
    
	
	<query id="SyncL3WithL2.SearchL3CoilComm.Select" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
SELECT A.*
FROM TBH02_COIL_COMM A
WHERE 1 = 1
AND A.COIL_NO LIKE :1||'%'
ORDER BY A.COIL_NO
        ]]>
    </query>


    <query id="SynchronizL2WithL3.InsertL2CoilComm.Insert" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
INSERT INTO TBH02_COIL_COMM2(COIL_NO, SLAB_NO)
SELECT :1, :2
FROM DUAL
        ]]>
    </query>	
	
	
    <query id="SyncL2WithL3.SearchL2CoilComm.Select" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
SELECT A.*
FROM TBH02_COIL_COMM2 A
WHERE 1 = 1
AND A.COIL_NO LIKE :1||'%'
ORDER BY A.COIL_NO
        ]]>
    </query>


</queryMap>