From oracle-l-bounce@freelists.org Wed Oct 5 11:24:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j95GO6Ee019358 for ; Wed, 5 Oct 2005 11:24:06 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j95GNwvX019336 for ; Wed, 5 Oct 2005 11:23:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 41EA51F24CB; Wed, 5 Oct 2005 11:23:13 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06824-07; Wed, 5 Oct 2005 11:23:13 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B15B51F1CD8; Wed, 5 Oct 2005 11:23:12 -0500 (EST) Message-ID: <000f01c5c9c8$e22d29e0$6501a8c0@camelopardalis> From: =?iso-8859-1?Q?Bj=F8rn_D=F6rr_Jensen?= To: "M.Godlewski" Cc: References: <20051005154826.78402.qmail@web42003.mail.yahoo.com> Subject: Re: XML -> DDL / DML Date: Wed, 5 Oct 2005 18:21:47 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01C5C9D9.A5946820" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-archive-position: 26382 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: B.D.Jensen@gmx.net Precedence: normal Reply-To: B.D.Jensen@gmx.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00,CLICK_BELOW, HTML_LINK_CLICK_HERE,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_000C_01C5C9D9.A5946820 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! Another group wants to see it relational. How to make an view on xml (oracle 8.1.7)? /Bj=F8rn ----- Original Message -----=20 From: M.Godlewski=20 To: B.D.Jensen@gmx.net=20 Sent: Wednesday, October 05, 2005 5:48 PM Subject: Re: XML -> DDL / DML Bjorn, You could build a relational view over the xml that is loaded into the = shredded tables. Is there really a need to store the data in the = database more then once? Bj=F8rn D=F6rr Jensen wrote: 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)=20 tables. Wich package can I use? Or is there an tool that convert the xml to=20 table-insert-scripts. I think I'll be able to handle solution using PL/SQL, Java or Perl. = Perhaps=20 there something useful for this kind in JDeveloper? Greeting & thanks Bj=F8rn=20 -- http://www.freelists.org/webpage/oracle-l -------------------------------------------------------------------------= ----- Yahoo! for Good Click here to donate to the Hurricane Katrina relief effort. ------=_NextPart_000_000C_01C5C9D9.A5946820 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi!
Another group wants to see it=20 relational.
How to make an view on xml (oracle=20 8.1.7)?
/Bj=F8rn
----- Original Message -----
From:=20 M.Godlewski
Sent: Wednesday, October 05, = 2005 5:48=20 PM
Subject: Re: XML -> DDL / = DML

Bjorn,
 
You could build a relational view over the xml that is loaded = into the=20 shredded tables.  Is there really a need to store the data in the = database more then once?

Bj=F8rn D=F6rr Jensen <B.D.Jensen@gmx.net>=20 wrote:
Hi!
I=20 have to take a xml-document through a web-service.
Are there = tools to=20 generate table-ddl's?
The xml-document should be "converted", = e.g. stored=20 in a set of (normalized)
tables.
Wich package can I use? Or = is there=20 an tool that convert the xml to
table-insert-scripts.

I = think=20 I'll be able to handle solution using PL/SQL, Java or Perl. Perhaps=20
there something useful for this kind in = JDeveloper?

Greeting=20 & thanks
Bj=F8rn=20 =

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

Yahoo! for Good
Click=20 here to donate to the Hurricane Katrina relief effort.=20 ------=_NextPart_000_000C_01C5C9D9.A5946820-- -- http://www.freelists.org/webpage/oracle-l