This is my first adventure into the wonderful world of XML.
I'm familiar with Oracle, PL/SQL, Basic, etc.
We've inherited two files. One has an XML extension and one has a CSV extension.
The .XML file has a name like ".....HeaderFormat.XML"
The CSV File is named ".....Header.CSV"
The CSV fields are terminated by a "|" except for the last field.
The last field is 2400 characters long and has an opening tag <AUTOsomething> <something2="value2" TYPE="Something3" ID=something2/> (more stuff with the 3 values) </AUTOsomething>
This last field looks like it is a bunch of 3 field records concantenated between the <AUTOsomething> tag.
I need to break the "|" terminated data as well as the last field data.
How can I load the information into Oracle?
I would love to make a CTL file and load it that way.
(On a side note... Why XML....I dont get it.)