Re: XSD with "required" attribute option related query

--000000000000511756059f5c5a06
Content-Type: text/plain; charset="UTF-8"

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 <[email protected]>
wrote:


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



-- 
Regards,
Mukul Gandhi

--000000000000511756059f5c5a06
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+PGRpdj5IaSBSYWpuZWVzaCw8L2Rpdj7CoCDCoCBJdCBzZWVtcyB0byBt
ZSB0aGF0LCB0aGlzIGlzc3VlIG1heSBiZSBzb2x2ZWQgd2l0aCBYTUwgU2NoZW1hIDEuMCBhcyB3
ZWxsLjxkaXY+PGJyPjwvZGl2PjxkaXY+V2l0aGluIHlvdXIgc2NoZW1hIGRvY3VtZW50LCBwbGVh
c2UgdHJ5IHJlcGxhY2luZyBmb2xsb3dpbmcgWFNEIGVsZW1lbnQgZGVjbGFyYXRpb24sPC9kaXY+
PGRpdj48YnI+PC9kaXY+PGRpdj4mbHQ7eHM6ZWxlbWVudCBuYW1lPSZxdW90O3doZXJlJnF1b3Q7
IG1heE9jY3Vycz0mcXVvdDsxJnF1b3Q7IG1pbk9jY3Vycz0mcXVvdDswJnF1b3Q7Jmd0OzwvZGl2
PjxkaXY+wqAgwqAgLi4uPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj53aXRoPC9kaXY+PGRpdj48
YnI+PC9kaXY+PGRpdj4mbHQ7eHM6ZWxlbWVudCBuYW1lPSZxdW90O3doZXJlJnF1b3Q7IG1heE9j
Y3Vycz0mcXVvdDsxJnF1b3Q7IG1pbk9jY3Vycz0mcXVvdDswJnF1b3Q7Jmd0Ozxicj7CoCDCoCAm
bHQ7eHM6Y29tcGxleFR5cGUmZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgJmx0O3hzOmNob2ljZSZndDs8
YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgJmx0O3hzOmVsZW1lbnQgbmFtZT0mcXVvdDtjb25kaXRp
b24mcXVvdDsgbWF4T2NjdXJzPSZxdW90O3VuYm91bmRlZCZxdW90OyBtaW5PY2N1cnM9JnF1b3Q7
MSZxdW90OyZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgJmx0O3hzOmNvbXBsZXhUeXBl
Jmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6c2ltcGxlQ29udGVudCZn
dDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgJmx0O3hzOmV4dGVuc2lvbiBiYXNl
PSZxdW90O3hzOnN0cmluZyZxdW90OyZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgJmx0O3hzOmF0dHJpYnV0ZSB0eXBlPSZxdW90O3hzOnN0cmluZyZxdW90OyBuYW1lPSZx
dW90O2FsaWFzMSZxdW90OyB1c2U9JnF1b3Q7cmVxdWlyZWQmcXVvdDsvJmd0Ozxicj7CoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6YXR0cmlidXRlIHR5cGU9JnF1b3Q7eHM6
c3RyaW5nJnF1b3Q7IG5hbWU9JnF1b3Q7Y29sMSZxdW90OyB1c2U9JnF1b3Q7cmVxdWlyZWQmcXVv
dDsvJmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6YXR0cmli
dXRlIHR5cGU9JnF1b3Q7eHM6c3RyaW5nJnF1b3Q7IG5hbWU9JnF1b3Q7b3BlcmF0b3ImcXVvdDsg
dXNlPSZxdW90O3JlcXVpcmVkJnF1b3Q7LyZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgJmx0O3hzOmF0dHJpYnV0ZSB0eXBlPSZxdW90O3hzOnN0cmluZyZxdW90OyBuYW1l
PSZxdW90O3N0cmluZyZxdW90OyB1c2U9JnF1b3Q7cmVxdWlyZWQmcXVvdDsvJmd0Ozxicj7CoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6YXR0cmlidXRlIHR5cGU9JnF1b3Q7
eHM6c3RyaW5nJnF1b3Q7IG5hbWU9JnF1b3Q7bnVtYmVyJnF1b3Q7IHVzZT0mcXVvdDtvcHRpb25h
bCZxdW90Oy8mZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgICZsdDt4czph
dHRyaWJ1dGUgdHlwZT0mcXVvdDt4czpzdHJpbmcmcXVvdDsgbmFtZT0mcXVvdDtkYXRlJnF1b3Q7
IHVzZT0mcXVvdDtvcHRpb25hbCZxdW90Oy8mZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgICZsdDsveHM6ZXh0ZW5zaW9uJmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCAmbHQ7L3hzOnNpbXBsZUNvbnRlbnQmZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgICZs
dDsveHM6Y29tcGxleFR5cGUmZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgICZsdDsveHM6ZWxl
bWVudCZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgJmx0O3hzOmVsZW1lbnQgbmFtZT0mcXVv
dDtjb25kaXRpb24mcXVvdDsgbWF4T2NjdXJzPSZxdW90O3VuYm91bmRlZCZxdW90OyBtaW5PY2N1
cnM9JnF1b3Q7MSZxdW90OyZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAmbHQ7eHM6
Y29tcGxleFR5cGUmZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgJmx0O3hz
OnNpbXBsZUNvbnRlbnQmZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgJmx0O3hzOmV4dGVuc2lvbiBiYXNlPSZxdW90O3hzOnN0cmluZyZxdW90OyZndDs8YnI+wqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAmbHQ7eHM6YXR0cmlidXRl
IHR5cGU9JnF1b3Q7eHM6c3RyaW5nJnF1b3Q7IG5hbWU9JnF1b3Q7YWxpYXMxJnF1b3Q7IHVzZT0m
cXVvdDtyZXF1aXJlZCZxdW90Oy8mZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgJmx0O3hzOmF0dHJpYnV0ZSB0eXBlPSZxdW90O3hzOnN0cmluZyZxdW90
OyBuYW1lPSZxdW90O2NvbDEmcXVvdDsgdXNlPSZxdW90O3JlcXVpcmVkJnF1b3Q7LyZndDs8YnI+
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAmbHQ7eHM6YXR0cmli
dXRlIHR5cGU9JnF1b3Q7eHM6c3RyaW5nJnF1b3Q7IG5hbWU9JnF1b3Q7b3BlcmF0b3ImcXVvdDsg
dXNlPSZxdW90O3JlcXVpcmVkJnF1b3Q7LyZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAmbHQ7eHM6YXR0cmlidXRlIHR5cGU9JnF1b3Q7eHM6c3RyaW5n
JnF1b3Q7IG5hbWU9JnF1b3Q7c3RyaW5nJnF1b3Q7IHVzZT0mcXVvdDtvcHRpb25hbCZxdW90Oy8m
Z3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgJmx0O3hz
OmF0dHJpYnV0ZSB0eXBlPSZxdW90O3hzOnN0cmluZyZxdW90OyBuYW1lPSZxdW90O251bWJlciZx
dW90OyB1c2U9JnF1b3Q7cmVxdWlyZWQmcXVvdDsvJmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6YXR0cmlidXRlIHR5cGU9JnF1b3Q7eHM6
c3RyaW5nJnF1b3Q7IG5hbWU9JnF1b3Q7ZGF0ZSZxdW90OyB1c2U9JnF1b3Q7b3B0aW9uYWwmcXVv
dDsvJmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7L3hz
OmV4dGVuc2lvbiZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAmbHQ7
L3hzOnNpbXBsZUNvbnRlbnQmZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
Jmx0Oy94czpjb21wbGV4VHlwZSZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgJmx0Oy94
czplbGVtZW50Jmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6ZWxlbWVudCBu
YW1lPSZxdW90O2NvbmRpdGlvbiZxdW90OyBtYXhPY2N1cnM9JnF1b3Q7dW5ib3VuZGVkJnF1b3Q7
IG1pbk9jY3Vycz0mcXVvdDsxJnF1b3Q7Jmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCZsdDt4czpjb21wbGV4VHlwZSZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAmbHQ7eHM6c2ltcGxlQ29udGVudCZndDs8YnI+wqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgJmx0O3hzOmV4dGVuc2lvbiBiYXNlPSZxdW90O3hz
OnN0cmluZyZxdW90OyZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgJmx0O3hzOmF0dHJpYnV0ZSB0eXBlPSZxdW90O3hzOnN0cmluZyZxdW90OyBu
YW1lPSZxdW90O2FsaWFzMSZxdW90OyB1c2U9JnF1b3Q7cmVxdWlyZWQmcXVvdDsvJmd0Ozxicj7C
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6YXR0
cmlidXRlIHR5cGU9JnF1b3Q7eHM6c3RyaW5nJnF1b3Q7IG5hbWU9JnF1b3Q7Y29sMSZxdW90OyB1
c2U9JnF1b3Q7cmVxdWlyZWQmcXVvdDsvJmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6YXR0cmlidXRlIHR5cGU9JnF1b3Q7eHM6c3Ry
aW5nJnF1b3Q7IG5hbWU9JnF1b3Q7b3BlcmF0b3ImcXVvdDsgdXNlPSZxdW90O3JlcXVpcmVkJnF1
b3Q7LyZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgJmx0O3hzOmF0dHJpYnV0ZSB0eXBlPSZxdW90O3hzOnN0cmluZyZxdW90OyBuYW1lPSZxdW90
O3N0cmluZyZxdW90OyB1c2U9JnF1b3Q7b3B0aW9uYWwmcXVvdDsvJmd0Ozxicj7CoCDCoCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAmbHQ7eHM6YXR0cmlidXRlIHR5
cGU9JnF1b3Q7eHM6c3RyaW5nJnF1b3Q7IG5hbWU9JnF1b3Q7bnVtYmVyJnF1b3Q7IHVzZT0mcXVv
dDtvcHRpb25hbCZxdW90Oy8mZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgIMKgIMKgIMKgICZsdDt4czphdHRyaWJ1dGUgdHlwZT0mcXVvdDt4czpzdHJpbmcmcXVv
dDsgbmFtZT0mcXVvdDtkYXRlJnF1b3Q7IHVzZT0mcXVvdDtyZXF1aXJlZCZxdW90Oy8mZ3Q7PGJy
PsKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgICZsdDsveHM6ZXh0ZW5z
aW9uJmd0Ozxicj7CoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCZsdDsveHM6
c2ltcGxlQ29udGVudCZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgJmx0
Oy94czpjb21wbGV4VHlwZSZndDs8YnI+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAmbHQ7L3hz
OmVsZW1lbnQmZ3Q7PGJyPsKgIMKgIMKgIMKgIMKgIMKgICZsdDsveHM6Y2hvaWNlJmd0Ozxicj7C
oCDCoCDCoCDCoCDCoCAmbHQ7L3hzOmNvbXBsZXhUeXBlJmd0Ozxicj7CoCDCoCDCoCZsdDsveHM6
ZWxlbWVudCZndDs8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PkkmIzM5O3ZlIHJlcGxhY2VkIG9u
ZSBvZiB0aGUgJmx0O3NlcXVlbmNlJmd0OyB3aXRoICZsdDtjaG9pY2UmZ3Q7LjwvZGl2PjxkaXY+
PGRpdj48ZGl2Pjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+PGRpdiBkaXI9Imx0ciIgY2xh
c3M9ImdtYWlsX2F0dHIiPk9uIE1vbiwgRmViIDI0LCAyMDIwIGF0IDE6MzkgUE0gUmFqbmVlc2gg
U2h1a2xhICZsdDs8YSBocmVmPSJtYWlsdG86cmFqbmVlc2hzaHVrbGFAZ21haWwuY29tIj5yYWpu
ZWVzaHNodWtsYUBnbWFpbC5jb208L2E+Jmd0OyB3cm90ZTo8YnI+PC9kaXY+PGRpdj7CoDwvZGl2
PjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowcHggMHB4IDBw
eCAwLjhleDtib3JkZXItbGVmdDoxcHggc29saWQgcmdiKDIwNCwyMDQsMjA0KTtwYWRkaW5nLWxl
ZnQ6MWV4Ij48ZGl2IGRpcj0ibHRyIj48ZGl2PkkgYW3CoCB3b3JraW5nIGluc2lkZSB0aGUgZGF0
YWJhc2UsIGl0IHdvbiYjMzk7dCBiZSBwb3NzaWJsZS48YnI+PC9kaXY+PGRpdj48cD5PcmFjbGUg
WE1MIERCIG9ubHkgc3VwcG9ydHMgWE1MIFNjaGVtYSAxLjAuPC9wPjwvZGl2PjwvZGl2PjwvYmxv
Y2txdW90ZT48ZGl2PsKgPC9kaXY+PC9kaXY+PGJyIGNsZWFyPSJhbGwiPjxkaXY+PGJyPjwvZGl2
Pi0tIDxicj48ZGl2IGRpcj0ibHRyIiBjbGFzcz0iZ21haWxfc2lnbmF0dXJlIj48ZGl2IGRpcj0i
bHRyIj48ZGl2IGRpcj0ibHRyIj48ZGl2IGRpcj0ibHRyIj48ZGl2PlJlZ2FyZHMsPGJyPk11a3Vs
IEdhbmRoaTwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2Pjwv
ZGl2Pg0K
--000000000000511756059f5c5a06--