Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Case insensitive XPATH

771030May 21 2010 — edited May 21 2010
Hi,

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
This post has been answered by chrisis on May 21 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2010
Added on May 21 2010
3 comments
2,204 views