This discussion is archived
2 Replies Latest reply: Oct 2, 2013 4:44 AM by odie_63 RSS

Access data in XML

TimWong765 Newbie
Currently Being Moderated

I have the following XML structure:


<TZR Action="Insert" OrgaT="400">

<Division id="4">

  <label language="de">ok</label>

  <label language="en">Live engl.</label>

<Productstructure id="300" Sparte="5">

  <label language="en">Live engl.</label>









I'd like to get



4, ok, Live engl, 300, 1, Live engl.




using XMLTYPE but I have no idea how to get id="4" or Sparte="1"







       passing XMLType(bfilename('XML_DATA_DIR', 'xxx.xml'), nls_charset_id('AL32UTF8'))

       columns Division_id       varchar2(30)       path 'Division/id'




Oracle 11.2.02 on Windows 2008.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points