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