1 Reply Latest reply: Oct 24, 2013 9:11 AM by odie_63 RSS

    External tables, XML files and XQuery - it's possible to use together?

    Neq

      I try to find some efficient way to load ~500 Excel worksheets (exported as XML 2003 format) into Oracle DB to further processing. Don't ask why not CSV... just not -.-

      I find some convinient way to transform Excel xml file to much more decent form, but I wonder if there is some way to use XQuery transformation in external table definition?

       

      I suspect it's not possible, so some alternative way?

      Solution: UTL_FILE -> XMLTYPE -> XQuery transformation -> Loading into table using PL/SQL (with xmltype and xquery inside) looks quite ugly...

       

      DB version: 11.2.0.3