PL/SQL create external table to parse xml block

 

create table ext_xml (xml_file_name varchar2(250), xml_content clob)
organization external (
type oracle_loader
default directory FLAT_LOC
access parameters (
records delimited by newline
nobadfile
nologfile
nodiscardfile
fields terminated by ‘,’
(xml_file_name char)
column transforms (xml_content from lobfile (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me  
New User Registration
*Required field