2 Replies Latest reply: Nov 22, 2012 1:30 AM by 974276 RSS

    loading xml file using owb

      Hi Gurus,

      I am new to owb and as per requirement we need to load xml files into oracle table using owb.

      below is the xml file:

      <book category="COOKING">
      <title lang="en">Everyday Italian</title>
      <author>Giada De Laurentiis</author>
      <book category="CHILDREN">
      <title lang="en">Harry Potter</title>
      <author>J K. Rowling</author>
      <book category="WEB">
      <title lang="en">Learning XML</title>
      <author>Erik T. Ray</author>

      please help me in loading above xml file using owb.
        • 1. Re: loading xml file using owb
          David Allan-Oracle
          You can leverage the XML SQL functions to extract from XML using the database, see the blog post below;

          For example to extract information from your XML document the following SQL can be generated from OWB;
          select extractValue(value(s), '/book/author'),
          extractValue(value(s), '/book/year'),
          extractValue(value(s), '/book/price') from
          ( select XMLType('<bookstore>
          +<book category="COOKING">+
          +<title lang="en">Everyday Italian</title>+
          +<author>Giada De Laurentiis</author>+
          +<book category="CHILDREN">+
          +<title lang="en">Harry Potter</title>+
          +<author>J K. Rowling</author>+
          +<book category="WEB">+
          +<title lang="en">Learning XML</title>+
          +<author>Erik T. Ray</author>+
          +</bookstore>') adoc from dual+) r,
          table(XMLSequence(extract(r.adoc, '/bookstore/book'))) s;

          • 2. Re: loading xml file using owb
            Hi All,

            How to load nested xml's in owb?

            I am new to OWB .... Please explain the steps so that i can follow :-(