Re: XML -> DDL / DML
- From: Bjørn Dörr Jensen <B.D.Jensen@xxxxxxx>
- To: "Michael McMullen" <ganstadba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Sep 2005 22:04:57 +0200
Hi!
Yes, it is always the same kind of xml-document (=>"definition always the
same").
version 8.1.7 :-(
Best regards
Bjørn
----- Original Message -----
From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
To: <B.D.Jensen@xxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, September 26, 2005 9:13 PM
Subject: Re: XML -> DDL / DML
Is the schema definition always the same? What version, 10g has lots of
new
xml stuff. I've only worked with 9i.
Here's what we did
Load the xml document into an xmltype column. Loop through each record in
your database containing the xmltype column. Check for the existence of
each
xml attribute. If you can have more than one occurrence of the attribute,
you have to check for that and loop through those. It's a lot of code and
very inflexible, but when they design an ordering system somebody should
have figured out that people might actually want to be able to report on
the
details of the orders.
You can load the schema definition into the database and then
automatically
load the xml into the proper tables and columns but this was not practical
for our purposes.
go to asktom.oracle.com and do a search on xml to get started.
----- Original Message -----
From: "Bjørn Dörr Jensen" <B.D.Jensen@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, September 26, 2005 2:42 PM
Subject: XML -> DDL / DML
Hi!
I have to take a xml-document through a web-service.
Are there tools to generate table-ddl's?
The xml-document should be "converted", e.g. stored in a set of
(normalized)
tables.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
