Home » SQL & PL/SQL » SQL & PL/SQL » parent value of xmlquery (Oracle 12C)
parent value of xmlquery [message #675981] Fri, 03 May 2019 06:28 Go to previous message
hakan_8
Messages: 3
Registered: May 2019
Junior Member
<Cases>
 <Case tag="IT653294" requesting="IT" >
       <Races>
        <Race scheduled="2018-06-01" id="100"/>
       </Races>
    </Case>
   <Case tag="IT831787" requesting="AB">
      <Races>
       <Race scheduled="2018-06-02" id="101" />
       <Race scheduled="2018-06-02" id="102" />
      </Races>
   </Case>
<Cases>

SELECT  
    FROM xml  xx
    ,XMLTABLE (XMLNAMESPACES (DEFAULT 'some_url') ,
    'for $i in Cases/Case/Races/Race return $i'
               PASSING xx.XMLDOC 
               COLUMNS scheduled  Date PATH '@scheduled'
                          id      NUMBER PATH '@id' ) x


this gives :

2018-06-01 100
2018-06-02 101
2018-06-02 102

I need the value of a parent node attribute

What I actually need is :
2018-06-01 100 IT653294
2018-06-02 101 IT831787
2018-06-02 102 IT831787

How can I get the parent value? Every help would be very appreciated.

Thanks in advance

 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ORA-00933: SQL command not properly ended
Next Topic: How to remove line breaks and put it in excel
Goto Forum:
  


Current Time: Fri Mar 29 02:17:05 CDT 2024