Hi
I have a table which has a XMLType column, the XSD is registered in DB. The XML is something like-
<primary>
<sub1>
<child1_1/>
<child1_2/>
<child1_3/>
</sub1>
<sub2>
<child2_1/>
<child2_2/>
<child2_3/>
</sub2>
<sub3>
<child31_1/>
<child3_2/>
<child3_3/>
</sub3>
</primary>
I want to create Index for child nodes. I have read that structure XML cant have collection as index it must be singleton.
So can any one tell me any workaround to create index for these node or anything i missed to read.
Thanks