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!

XmlTable and XQuery: ignore case sensitivity

Yellow75Aug 27 2015 — edited Aug 31 2015

Hi,

In Oracle Database 11g 11.2.0.3.0 64bit Production, I would like to know if it is possible, in a query using XMLTABLE and XQuery to ignore case sensitivity; for example, suppose we have an xml files with tags:

/Warehouse

/Warehouse/WaterAccess

/Warehouse/RailAccess

We execute the following (example from http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions253.htm#SQLRF06232):

SELECT warehouse_name warehouse,

  warehouse2."Water", warehouse2."Rail"

  FROM warehouses,

  XMLTABLE('/Warehouse'

  PASSING warehouses.warehouse_spec

  COLUMNS

  "Water" varchar2(6) PATH '/Warehouse/WaterAccess',

  "Rail" varchar2(6) PATH '/Warehouse/RailAccess')

  warehouse2;

WAREHOUSE Water Rail

----------------------------------- ------ ------

Southlake, Texas Y N

San Francisco Y N

New Jersey N N

Seattle, Washington N Y

But, for some reasons, the next xml file contains the following tags (some letters lowercase):

/warehouse

/warehouse/WaterAccess

/warehouse/Railaccess

the same query will fail.

Is there any workaround (e.g. use a sort of UPPER)?

Thanks,

Igor

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2015
Added on Aug 27 2015
2 comments
1,498 views