Hi All,
I want to load XML file data into database.
There is seperate XML file for each record (2000 record) and I want to
load these records into a single Oracle database table
using SQL*Loader utility.
I tried to load these records by converting the xml file to text file.
But In this case i have to convert each XML file to a text file so it
does not suite my requirement.
My question are
1. Is it possible to load XML file data directly to oracle database
table using "SQL*LOADER "?
2. If it is not what should be the convenient way to do it?
3. As there are 2000 records how to load these records in one request?
Plz. Help me out in this regard.
Thanks a lot.
Rakesh Patel
I want to load XML file data into database.
There is seperate XML file for each record (2000 record) and I want to
load these records into a single Oracle database table
using SQL*Loader utility.
I tried to load these records by converting the xml file to text file.
But In this case i have to convert each XML file to a text file so it
does not suite my requirement.
My question are
1. Is it possible to load XML file data directly to oracle database
table using "SQL*LOADER "?
2. If it is not what should be the convenient way to do it?
3. As there are 2000 records how to load these records in one request?
Plz. Help me out in this regard.
Thanks a lot.
Rakesh Patel