Oracle Database - Xml External Table

> Database > Oracle Database

1 - About

Advertising

3 - 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:

4 - Articles

db/oracle/xml.txt · Last modified: 2017/09/06 19:29 by gerardnico