Re: XML -> DDL / DML

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_at_hotmail.com> To: <B.D.Jensen_at_gmx.net>; <oracle-l_at_freelists.org> 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_at_gmx.net>
> To: <oracle-l_at_freelists.org>
> 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.
>>
>

--
http://www.freelists.org/webpage/oracle-l