甲骨文11g。我发现如果我将NOENTITYESCAPING添加到XMLELEMENT函数,它会很好地关闭实体转义。但是,当我将结果传递给EXTRACT时,转义似乎又回来了。selectxmlelement(NOENTITYESCAPINGe,id,'->')from(selectlevelasidfromdualconnectbylevel')---------------------------------------1->2->3->4->5->现在,添加EXTRACT:selectxmlelement(NOENTITYESCAPINGe,id,'->').extract('//