oracle xmlconcat()函数-oracle版本19c上缺少标记名

5anewei6  于 2021-07-24  发布在  Java
关注(0)|答案(1)|浏览(440)

当我在oracle19c上运行第一个sql查询时,<strange\u elem>丢失了。为什么?是甲骨文的错误吗?

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 22 10:46:19 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Last Successful login time: Wed Jul 22 2020 10:31:51 +02:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

sql> -- missing <strange_elem> !!!
sql> SELECT
  2     Xmlforest(
  3          xmlconcat(xmlelement("data", 'abc')) as "strange_elem"
  4          ,dbms_utility.get_time  "next"
  5      )||' ' result
  6      FROM dual;
RESULT
----------------------------------------------------------------------------------------------------
<data>abc</data><next>1036336429</next>
sql> -- <strange_elem> is present when <next> elem is ommited
sql> SELECT
  2     Xmlforest(
  3          xmlconcat(xmlelement("data", 'abc')) as "strange_elem"
  4      )||' ' result
  5      FROM dual;
RESULT
----------------------------------------------------------------------------------------------------
<strange_elem><data>abc</data></strange_elem>
sql> -- <strange_elem> is present when <next> elem value is not function, but hard coded value !
sql> SELECT
  2     Xmlforest(
  3          xmlconcat(xmlelement("data", 'abc')) as "strange_elem"
  4          ,'1' "next"
  5      )||' ' result
  6      FROM dual;
RESULT
----------------------------------------------------------------------------------------------------
<strange_elem><data>abc</data></strange_elem><next>1</next>

在oracle12c上,我在所有3个sql查询中得到相同的结果<奇怪的元素>出现在结果中。

gxwragnw

gxwragnw1#

检查此文档id 2716320.1并应用修补程序

相关问题