I have a table with xml column named xmlvalue.let xml value in those column are like shown below
<z>
<a>
<b>1</b>
<c>2</c>
</a>
<a>
<b>4</b>
<c>5</c>
.
.
.
so many tags similar to above
.
.
</a>
</z>
I want to add a new node called <new>here value should betaken from another column</new> inside the <z><a> for every row in that column with <new> tag having a value which is taken from another column "abc" for that row.(column abc is not a xml column) which is in same table.How can i do it using xml query or sql query?
Thank you