create or replace directory utl_extdir as 'C:\TEMP';

drop table ext_table;

create table ext_table(
       id          number,
       description varchar2(50),
       xml         varchar2(50)
    )
    organization external(
      default directory utl_extdir
      access parameters(
         records delimited by newline
         fields terminated by ','
         (id           char,
          description  char,
          xml          char)
      )
      location ('test_file.txt')
    );

create or replace view ext_table_xml as
select id
      ,description
      ,xmltype(xml) xml
from   ext_table;