CREATE TABLE xml_tab (   id        NUMBER,   xml_data  XMLTYPE )

CREATE TABLE xml_tab (   id        NUMBER,   xml_data  XMLTYPE )

INSERT INTO xml_tab VALUES(4,xmltype('<?xml version="1.0" encoding="UTF-8" standalone="yes"?> 
 
<Jobsdata> 
 
    <jobList> 
 
        <jobData> 
 
            <job> 
 
                <name>JOBNAME10</name> 
                <document> 
                	<fileID>100</fileID> 
                </document> 
                <document> 
                	<fileID>1000</fileID> 
                </document> 
                <directoryid>D100</directoryid> 
 
                <schedule> 
 
                    <frequency>IMMEDIATE</frequency> 
 
                </schedule> 
 
                <targetType>host</targetType> 
 
                <targets> 
 
                    <name>node100.localdomain</name> 
 
                    <type>host</type> 
 
                </targets> 
 
                <targets> 
 
                    <name>node200.localdomain</name> 
 
                    <type>host</type> 
 
                </targets> 
 
            </job> 
 
        </jobData> 
 
        <jobData> 
 
            <job> 
 
                <name>JOBNAME20</name> 
                <document> 
                	<fileID>200</fileID> 
                </document> 
                <directoryid>D200</directoryid> 
 
                <schedule> 
 
                    <frequency>REPEAT_BY_DAYS</frequency> 
 
                </schedule> 
 
                <status>ACTIVE</status> 
 
                <targetType>host</targetType> 
 
                <targets> 
 
                    <name>node300.localdomain</name> 
 
                    <type>host</type> 
 
                </targets> 
 
            </job> 
 
        </jobData> 
 
        <jobData> 
 
            <job> 
 
                <name>JOBNAME300</name> 
                <directoryid>D300</directoryid> 
 
                <schedule> 
 
                    <days>3</days> 
 
                    <days>5</days> 
 
                    <frequency>WEEKLY</frequency> 
 
                </schedule> 
 
                <targets> 
 
                    <name>node400.localdomain</name> 
 
                    <type>host</type> 
 
                </targets> 
 
            </job> 
 
        </jobData> 
 
    </jobList> 
 
</Jobsdata>'))