1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

PL/SQL XML CLOB Data processing

Discussion in 'SQL PL/SQL' started by depakjan, Sep 6, 2010.

  1. depakjan

    depakjan Guest

    Hi Guys,

    i have a table which has a CLOB data type column that holds a XML. i need select the some of the nodes from it.. sample XML looks like this.. there are actually 100 or more nodes totally but i want to select some 4 of them as a coloumn for my select query. please help me out in this guys.

    Code (Text):

    <?xml version="1.0" encoding="UTF-8"?><alert>
     
        <tab0 comment="section in XSL component" name="Initial Information">
            <details>  
                <Priority>0001</Priority>
                <DateVRUClaimInitiated>2010-06-29</DateVRUClaimInitiated>
           
            </details>
            <contacts comment="grid in XSL component">
                many child nodes here
            </contacts>        
        </tab0>
     
        <tab1 comment="section in XSL component" name="Additional Information">
            <details comment="list collection in XSL component">
                Many child nodes here
            </details>
            <IPAddresses>
                Many child nodes here
            </IPAddresses>     
            <ANIPhones>
                Many child nodes here
            </ANIPhones>
        </tab1>
       
        <tab2 name="Loss Avoidance">
            <losstable>
                Many child nodes here  
            </losstable>
            <summary>
                Many child nodes here  
            </summary>
            <accounts>
                Many child nodes here
            </accounts>
        </tab2>
       
     
        <tab3 name="R &amp; R">    
            <narrative>
                Many child nodes here  
            </narrative>
        </tab3>
     
    </alert>