Home » SQL & PL/SQL » SQL & PL/SQL » How to Bulk load an XML file content into the DB (Windows Vista)
How to Bulk load an XML file content into the DB [message #279920] Sun, 11 November 2007 20:38 Go to next message
Akashyk
Messages: 2
Registered: November 2007
Location: Boston USA
Junior Member

Hi All,

Could someone help me with my requirement to simulate a scenario where I should be able to read a file content, extract each field based on the delimiter "|" and BULK LOAD the values into the table? I am using Oracle 10G, Oracle Jdev. Is there an easier procedure in Jdeveloper to do it?

Akash
Re: How to Bulk load an XML file content into the DB [message #279922 is a reply to message #279920] Sun, 11 November 2007 21:25 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Visit http://asktom.oracle.com & do a keyword search on the following string:
load "XML file"
Then read & follow the fine coding examples provides by Tom Kyte
Previous Topic: text file generation
Next Topic: REPLACING only on specified locations
Goto Forum:
  


Current Time: Tue Dec 06 02:48:29 CST 2016

Total time taken to generate the page: 0.07034 seconds