Re: XML import into database (without XMLTYPE)

From: Robert A.M. van Lopik <lopik_at_mail.telepac.pt>
Date: Mon, 24 Feb 2003 09:11:13 -0000
Message-ID: <3e5a153b$0$645$a729d347@news.telepac.pt>

"Nemesis" <spam.godsanus_at_hotmail.com> wrote in message news:QQ96a.71290$Jd.8228_at_afrodite.telenet-ops.be...
> I have an XML file which holds data for a regular table. This table has
> been defined in an Oracle 9.2.0.2 database. Is there a simple way to
import
> this XML file into that table with the native XML possibilities of Oracle
?
>
> All I read about XML in Oracle 9i seems to be about an XMLTYPE datatype,
but
> that's not exactly what I'm looking for, I think.
>
> Thx,
> Peter

When it is about regular tables instead of the XML DB stuff, you would probably want to look at XSU (XML SQL Utility) for loading and unloading XML. Look in the Oracle 9i XML Developers Kit Guide.

hth
rob van lopik Received on Mon Feb 24 2003 - 03:11:13 CST