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