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?


      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: