Case insensitive XPATH
771030May 21 2010 — edited May 21 2010Hi,
I have the following XMLs stored in a column.
<root>
<abc>abc</abc>
<def>def</def>
</root>
<root>
<ABC>abc</ABC>
<DEF>def</DEF>
</root>
Is there someway to use a case insensitive search in my extractValue so that I don't have to write it twice?
extractValue (XML_CLOB, /root/abc)
extractValue (XML_CLOB, /root/ABC)
Thanks and Regards,
A