Oracle Database - Xml External Table

1 - About

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:

  • EXT_TABLE_DIR is an external directory

4 - Articles


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap