Question

在Oracle XML DB(11g R2)中,我曾处理过以下问题:

表格中一个名为“xml_document”的XMLType栏页: 1

<?xml encoding="utf-8" ?>
<books>
    <book>
        <author>AUTHORNAME1</author>
        <title>TITLE1</title>
        <price>12.33</price>
    </book>
    <book>
        <author>AUTHORNAME2</author>
        <title>TITLE2</title>
        <price>9.55</price>
    </book>
    <book>
        <author>AUTHORNAME3</author>
        <title>TITLE3</title>
        <price>15.00</price>
    </book>
</books>

现在,我想做的是,把所有书籍的标题改为“价格”10,作为附加的“成本”标签。

  for $book in ora:view("XML_TABLE")//books/book where $book/price > 10 return replace value of node $book/title with concat($book/title/text(),"-expensive")

因此,在我执行OraclekouDeveloper一案之后,由此产生的XML内容将如下。

<?xml encoding="utf-8" ?>
<books>
    <book>
        <author>AUTHORNAME1</author>
        <title>TITLE1-expensive</title>
        <price>12.33</price>
    </book>
    <book>
        <author>AUTHORNAME2</author>
        <title>TITLE2</title>
        <price>9.55</price>
    </book>
    <book>
        <author>AUTHORNAME3</author>
        <title>TITLE3-expensive</title>
        <price>15.00</price>
    </book>
</books>

我已经尝试与挪威人民民主党(UPDATEXML)、XML RequestRY(XML)和XMLTABLE(XML)程序一道这样做,但不能向前推进。

任何帮助都将受到赞赏。

Answer 1

when is no XQuery statement (though I cannot tell about Oracle XQuery). Try where.
String concatenation is done using concat(str1, [...], str2), not the +-operator.

询问:

for $book in ora:view("XML_TABLE")//book
where $book/price > 10
return
  replace value of node $book/title
  with concat($book/title/text(), "-expensive")

友情链接