Using UpdateXML on a node with NULL value and a namespace attribute
(Doc ID 960397.1)
Last updated on APRIL 29, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.0 [Release 10.2 to 11.2]Information in this document applies to any platform.
Information in this document applies to any platform.
Goal
Given the following XML document, how can the EMAIL element be updated?
<ns0:EMPLOYEES xmlns:ns0="http://schemas.oracle.com/HR/EmployeeInfo/">
<ns0:EMPLOYEE PERSONID="1234">
<ns0:FIRST_NAME>Ellen</ns0:FIRST_NAME>
<ns0:LAST_NAME>xxxx</ns0:LAST_NAME>
<ns0:EMAIL></ns0:EMAIL>
<ns0:PHONE_NUMBER>515.000.0000</ns0:PHONE_NUMBER>
</ns0:EMPLOYEE>
</ns0:EMPLOYEES>
<ns0:EMPLOYEE PERSONID="1234">
<ns0:FIRST_NAME>Ellen</ns0:FIRST_NAME>
<ns0:LAST_NAME>xxxx</ns0:LAST_NAME>
<ns0:EMAIL></ns0:EMAIL>
<ns0:PHONE_NUMBER>515.000.0000</ns0:PHONE_NUMBER>
</ns0:EMPLOYEE>
</ns0:EMPLOYEES>
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |