Oracle：如何使用updateXML更新文档中的多个节点？

-- 假设有一个名为employees的表，其中包含一个名为employee_data的XMLType列
-- 示例数据：
-- <employees>
--  <employee>
--     <id>1</id>
--     <name>John Doe</name>
--     <department>IT</department>
--   </employee>
--  <employee>
--     <id>2</id>
--     <name>Jane Smith</name>
--     <department>HR</department>
--   </employee>
-- </employees>

-- 更新所有员工的部门为"Marketing"
UPDATE employees
SET employee_data = updateXML(employee_data, '/employees/employee/department/text()', 'Marketing')
WHERE employee_data.existsNode('/employees/employee/department') = 1;

-- 更新id为1的员工的姓名为"John Smith"
UPDATE employees
SET employee_data = updateXML(employee_data, '/employees/employee[id=1]/name/text()', 'John Smith')
WHERE employee_data.existsNode('/employees/employee[id=1]/name') = 1;