Re: XML -> DDL / DML
- From: Bjørn Dörr Jensen <B.D.Jensen@xxxxxxx>
- To: "M.Godlewski" <mcgodlewski@xxxxxxxxx>
- Date: Wed, 5 Oct 2005 18:21:47 +0200
Hi!
Another group wants to see it relational.
How to make an view on xml (oracle 8.1.7)?
/Bjørn
----- Original Message -----
From: M.Godlewski
To: B.D.Jensen@xxxxxxx
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ørn Dörr Jensen <B.D.Jensen@xxxxxxx> 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)
tables.
Wich package can I use? Or is there an tool that convert the xml to
table-insert-scripts.
I think I'll be able to handle solution using PL/SQL, Java or Perl. Perhaps
there something useful for this kind in JDeveloper?
Greeting & thanks
Bjørn
--
//www.freelists.org/webpage/oracle-l
------------------------------------------------------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
Other related posts:
