SQL>
SQL> CREATE TABLE myTable(
2 id NUMBER PRIMARY KEY,
3 emps XMLType NOT NULL
4 );
Table created.
SQL>
SQL> INSERT INTO myTable VALUES
2 (1, xmltype('
3
4
5 address
6
7
8 );
1 row created.
SQL>
SQL>
SQL> update myTable
2 set emps = updatexml(emps, '/emps/emp/home_address/text()','New York')
3 where id = 1;
1 row updated.
SQL> commit;
Commit complete.
SQL>
SQL>
SQL> drop table myTable;
Table dropped.
SQL>
SQL>
SQL>