Create schema & load data via XML files [message #280446] |
Tue, 13 November 2007 11:51 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
I've been given 2 XML files, abc.xsd & abc.xml, which supposedly contain the table
definitions (xsd) and the actual table data (xml).
My challenge to figure how to create the tables & actually load the data into the tables.
I want these tables to be standard relational tables & not "XML" tables.
I am posting this in Utilities forum, because I suspect the solution will be some
sort of custom PL/SQL code calling some Oracle supplied stored procedure which will
do the necessary transformation.
If I can eventually create the tables & load the data directly from these 2 files;
that would be great.
Otherwise I'd be satisfied with creating text files containing valid SQL statements
for the CREATE & INSERT operations.
In case it matters, I hope to load this data into a new 11g DB on a Linux system.
I am ready, willing & able to RTFM, if somebody would be so kind as to point me at 1 or
more of the FM where such a process is described or where coding examples can be found.
Thanks In Advance
[Updated on: Tue, 13 November 2007 11:52] by Moderator Report message to a moderator
|
|
|