Loading XML-Data in a normal Database table, searching for a good book for SQL Loader
I am new at this community and I have an problem with loading XML-Data into a database table. I searched the internet for information about loading XML data, but I had little success. I visited my local book store, but I couldn't find a book that helped.
I made an table:
create table diamos_import2.ABU_Kontodaten
(PostenNr number(20),
Postentext varchar2(255),
Postenreferenz varchar2(255),
PostenErstelltAm varchar2(10),
PostenBetrag varchar2(20),
PostenKennz varchar2(19));
A datafile of following kind:
<?xml version="1.0" encoding="UTF-8"?>
<DOCUMENT_AbuKontenblatt>
<Kontenblatt>
<Kontenliste>
<Konto>
<KontoNr>Ausgabeaufgeld 1</KontoNr>
<KontoKurzbezeichnung>Ausgabeaufgeld 1</KontoKurzbezeichnung>
<KontoWaehrung>EUR Euro</KontoWaehrung>
<KontoSaldoVorher>-376.744,95</KontoSaldoVorher>
<KontoSaldoVorherKennz>Soll</KontoSaldoVorherKennz>