Re: XSD with "required" attribute option related query

Hi Rajneesh,
    It seems to me that, this issue may be solved with XML Schema 1.0 as
well.

Within your schema document, please try replacing following XSD element
declaration,

<xs:element name="where" maxOccurs="1" minOccurs="0">
    ...

with

<xs:element name="where" maxOccurs="1" minOccurs="0">
    <xs:complexType>
         <xs:choice>
              <xs:element name="condition" maxOccurs="unbounded"
minOccurs="1">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:string">
                      <xs:attribute type="xs:string" name="alias1"
use="required"/>
                      <xs:attribute type="xs:string" name="col1"
use="required"/>
                      <xs:attribute type="xs:string" name="operator"
use="required"/>
                      <xs:attribute type="xs:string" name="string"
use="required"/>
                      <xs:attribute type="xs:string" name="number"
use="optional"/>
                      <xs:attribute type="xs:string" name="date"
use="optional"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element name="condition" maxOccurs="unbounded"
minOccurs="1">
                 <xs:complexType>
                     <xs:simpleContent>
                         <xs:extension base="xs:string">
                             <xs:attribute type="xs:string" name="alias1"
use="required"/>
                             <xs:attribute type="xs:string" name="col1"
use="required"/>
                             <xs:attribute type="xs:string" name="operator"
use="required"/>
                             <xs:attribute type="xs:string" name="string"
use="optional"/>
                             <xs:attribute type="xs:string" name="number"
use="required"/>
                              <xs:attribute type="xs:string" name="date"
use="optional"/>
                          </xs:extension>
                       </xs:simpleContent>
                     </xs:complexType>
                </xs:element>
                <xs:element name="condition" maxOccurs="unbounded"
minOccurs="1">
                     <xs:complexType>
                         <xs:simpleContent>
                            <xs:extension base="xs:string">
                                <xs:attribute type="xs:string"
name="alias1" use="required"/>
                                <xs:attribute type="xs:string" name="col1"
use="required"/>
                                <xs:attribute type="xs:string"
name="operator" use="required"/>
                                <xs:attribute type="xs:string"
name="string" use="optional"/>
                                <xs:attribute type="xs:string"
name="number" use="optional"/>
                                <xs:attribute type="xs:string" name="date"
use="required"/>
                            </xs:extension>
                         </xs:simpleContent>
                      </xs:complexType>
                 </xs:element>
            </xs:choice>
          </xs:complexType>
     </xs:element>

I've replaced one of the <sequence> with <choice>.

On Mon, Feb 24, 2020 at 1:39 PM Rajneesh Shukla <rajneeshshukla@gmail.com>
wrote:


> I am  working inside the database, it won't be possible.
>
> Oracle XML DB only supports XML Schema 1.0.
>



-- 
Regards,
Mukul Gandhi