+ -
当前位置:首页 → 问答吧 → 请问如何在SQL中使用多条件的XPath表达式

请问如何在SQL中使用多条件的XPath表达式

时间:2011-09-09

来源:互联网

在SQL中使用函数Insertchildxml,其中Xpath表达式需要使用多个条件,主要是用于判断多个属性。

在Insertchildxml 、APPENDCHILDXML、EXTRACT函数中,都不能用多条件的XPath表达式?

-----------------------------------------Insertchildxml函数例子如下,这样正常:-------------------------

Select Appendchildxml(Appendchildxml(Appendchildxml(Appendchildxml(Xmltype('<?xml version="1.0" encoding="gb2312"?><Document></Document>'),
  '/Document',
  Xmlelement("FileInfo",
  Xmlforest('张三' As "姓名", '3321' As "学号",
  '大连' As "原籍", '测试部' As "单位"))),
  '/Document',
  Xmlelement("Compend", Xmlattributes('0' As "ID", '1' As "No"))),
  '/Document', Xmlelement("Compend", Xmlattributes('1' As "ID", '12' As "No"))),
  '/Document/descendant::Compend[@ID=0]',
  Xmlelement("Text", Xmlattributes('1' As "ID", '不空' As "Name"), 'AA')) As Xxml
From Dual

-------------------------------------------------分隔线 以下就不正常-------------------------------

Select Appendchildxml(Appendchildxml(Appendchildxml(Appendchildxml(Xmltype('<?xml version="1.0" encoding="gb2312"?><Document></Document>'),
  '/Document',
  Xmlelement("FileInfo",
  Xmlforest('张三' As "姓名", '3321' As "学号",
  '大连' As "原籍", '测试部' As "单位"))),
  '/Document',
  Xmlelement("Compend", Xmlattributes('0' As "ID", '1' As "No"))),
  '/Document', Xmlelement("Compend", Xmlattributes('1' As "ID", '12' As "No"))),
  '/Document/descendant::Compend[@ID=0 And @No=1]',
  Xmlelement("Text", Xmlattributes('1' As "ID", '不空' As "Name"), 'AA')) As Xxml
From Dual

作者: apiaoz   发布时间: 2011-09-09

不清楚,期待解决方案

作者: azj1001   发布时间: 2011-09-09