XinYu_RZMES/.svn/pristine/3c/3c47c61e90e771cc300ae956714e17aef5d1fa1e.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Project T">
	
	
	<query id="SearchSendInfo01.Select" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
SELECT A.*
FROM TBZ00_COMMCD A
WHERE 1 = 1
AND A.LG_CD = 'A01001'
ORDER BY A.CD_SEQ
        ]]>
    </query>
    
	
	<query id="SearchSendInfo02.Select" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
SELECT A.*
FROM TBZ00_COMMCD A
WHERE 1 = 1
AND A.LG_CD = 'A01002'
ORDER BY A.CD_SEQ
        ]]>
    </query>


    <query id="DeleteL2Table01.Delete" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
DELETE FROM TEST_COMMCD WHERE LG_CD = 'A01001'
        ]]>
    </query>    


    <query id="InsertL2Table01.Insert" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
INSERT INTO TEST_COMMCD(LG_CD, SM_CD
                      , LG_NM, SM_CFNM, SM_CSNM, SM_EFNM, SM_ESNM
                      , BIZ_CLF
                      , CD_SEQ, USED_YN, CD_DESC, CD_LEN
                      , MOD_ID, MOD_DATE) 
SELECT :1, :2
     , :3, :4, :5, :6, :7
     , :8
     , :9, :10, :11, :12
     , :13, :14
FROM DUAL
        ]]>
    </query>	


    <query id="DeleteL2Table02.Delete" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
DELETE FROM TEST_COMMCD WHERE LG_CD = 'A01002'
        ]]>
    </query>    


    <query id="InsertL2Table02.Insert" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
INSERT INTO TEST_COMMCD(LG_CD, SM_CD
                      , LG_NM, SM_CFNM, SM_CSNM, SM_EFNM, SM_ESNM
                      , BIZ_CLF
                      , CD_SEQ, USED_YN, CD_DESC, CD_LEN
                      , MOD_ID, MOD_DATE) 
SELECT :1, :2
     , :3, :4, :5, :6, :7
     , :8
     , :9, :10, :11, :12
     , :13, :14
FROM DUAL
        ]]>
    </query>    


    <query id="ModifyCallResults.Update" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
UPDATE TBZ00_COMMCD
SET MOD_DATE = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
WHERE LG_CD = :1 AND SM_CD = :2
        ]]>
    </query>    





</queryMap>