Oracle Database - Xml External Table

Card Puncher Data Processing

About

Xml externl table

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:

Articles





Discover More
Card Puncher Data Processing
Oracle Database

Documentation about the Oracle database
Card Puncher Data Processing
Oracle Database - Oracle XML DB

Oracle XML DB is a set of Oracle Database technologies related to high-performance XML storage and retrieval. It provides native XML support by encompassing both SQL and XML data models in an interoperable...



Share this page:
Follow us:
Task Runner