XML : loading xml with sql loader-clarification

I want to load an XML file with sql loader in oracle 11g release 2 xe.

I've seen two ways:

  • 1 example

load data

infile * "str ''"

INSERT

into table address_book

TRUNCATE

    FIELDS(             dummy1 filler char(2000) terminated by "<contact>",             contact_name char(2000) enclosed by "<contact_name>" and "</contact_name>",           .....            )    

BEGINDATA

.....

-2 example.

external table

http://www.liberidu.com/blog/2014/07/18/loading-xml-documents-into-an-oracle-database/.

I don't understand, when you use 1 and when you use 2. ?? and There are also other ways to load xml sql loader. in oracle 11g release 2 xe ??

thanks for clarification

No comments:

Post a Comment