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

Report message to a moderator

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

Report message to a moderator

Previous Topic: text file generation
Next Topic: REPLACING only on specified locations
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 16:48:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.