XinYu_RZMES/.svn/pristine/da/da7a270ea1e584e485ac3ea115e7a390a046b199.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Project T">
	<query id="SearchHierachicalData.Select" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
SELECT LEVEL, A.*
FROM TBD01_MATDN_RST A
START WITH A.PMAT_SPEC_SEQ = :1
CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ
        ]]>
    </query>
    <query id="SearchHierachicalData.AllSelect" desc="Hierachical Example.Select" fetchSize="10">
        <![CDATA[
SELECT LEVEL, A.*
FROM TBD01_MATDN_RST A
START WITH A.PMAT_SPEC_SEQ IS NULL
CONNECT BY PRIOR A.MAT_SPEC_SEQ = A.PMAT_SPEC_SEQ
        ]]>
    </query>
</queryMap>