Create ordinary table out of XML Schema

[Andreas Bergmeier]

Hi - I searched quite a bit now but still it seems that one topic was
never brought up on oracles xml handling (9i btw). Could anybody tell
me how it is possible to create a table out of a xml schema (I don't
care about the format the xml must have - the important thing is it
being xml)? I can add data to the table using xml, get the schema out
in xml and so on but there seems no topic that handles automatic table
creation using a xml schema (apart from a xmltype).

Best regards
Andreas Bergmeier

[Douglas Hawthorne]

Re: Create ordinary table out of XML Schema

"Andreas Bergmeier" <andreas.bergme ier@compass-systems.dewrote in message
news:7a78c9d2.0 404270626.5d7cf 951@posting.goo gle.com...

Hi - I searched quite a bit now but still it seems that one topic was
never brought up on oracles xml handling (9i btw). Could anybody tell
me how it is possible to create a table out of a xml schema (I don't
care about the format the xml must have - the important thing is it
being xml)? I can add data to the table using xml, get the schema out
in xml and so on but there seems no topic that handles automatic table
creation using a xml schema (apart from a xmltype).
>
Best regards
Andreas Bergmeier

Andreas,

Have you read the article, "Make XML Native and Relative ", by Johnathon
Gennick at http://otn.oracle.com/oramag/oracle/03-jan/o13xml.html ? In that
article, Johnathon takes an XML schema to create object-relational tables.

Douglas Hawthorne