Re: create an oracel table from a XSD file

From: Rob Wolfe <rob.wolfe_at_rob-wolfe.com>
Date: Sun, 19 Feb 2006 19:58:13 +0000 (UTC)
Message-ID: <45fd995b1a7c8d8c8037c0ab0b250_at_news.giganews.com>

> I would like to be able to take an XSD file and create an Oracle
> table.
> I don't want to create a table of xmltype, just a normal table. Is
> there a program out there that can do this? Or how can this be done?
> Thanks.
>
> Jeff
>

XML is hierarchical. Relational datebases aren't (without some twiddling). What would be your expected table definition from this XSD definition {copyright  from the w3schools }

Rob Wolfe

<?xml version="1.0" encoding="ISO-8859-1" ?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="shiporder">
 <xs:complexType>
  <xs:sequence>
   <xs:element name="orderperson" type="xs:string"/>    <xs:element name="shipto">
    <xs:complexType>

     <xs:sequence>
      <xs:element name="name" type="xs:string"/>
      <xs:element name="address" type="xs:string"/>
      <xs:element name="city" type="xs:string"/>
      <xs:element name="country" type="xs:string"/>
     </xs:sequence>

    </xs:complexType>
   </xs:element>
   <xs:element name="item" maxOccurs="unbounded">     <xs:complexType>

     <xs:sequence>
      <xs:element name="title" type="xs:string"/>
      <xs:element name="note" type="xs:string" minOccurs="0"/>
      <xs:element name="quantity" type="xs:positiveInteger"/>
      <xs:element name="price" type="xs:decimal"/>
     </xs:sequence>

    </xs:complexType>
   </xs:element>
  </xs:sequence>
  <xs:attribute name="orderid" type="xs:string" use="required"/>  </xs:complexType>
</xs:element>

</xs:schema> Received on Sun Feb 19 2006 - 20:58:13 CET