About

Xml externl table

Articles Related

Example

select
   ,      model.code
   ,      model.description
   from
          xmltable(
                   'Path/For/OneRecord'
                   passing xmltype(
                                     bfilename(
                                                 'EXT_TABLE_DIR'
                                               , 'FileName.xml'
                                              )
                                   , nls_charset_id(
                                                    'WE8ISO8859P1'
                                                   )
                                  )
                   columns
                           code              varchar2(4000) path 'code'
                   ,       description       varchar2(4000) path 'description'
                  ) model

where:

• EXT_TABLE_DIR is an external directory

Articles

• Managing XML using Oracle's XMLDB
• Oracle Database - PL/SQL Package DBMS_XDB
• Oracle® Database SQL Reference 10g Release 2 (10.2) - Part Number B14200-02 - Using XML in SQL Statements