how to rename XML attribute?

tempe · #1 (**permalink**) 01-27-12, 02:21

Hello

How to rename xml attribute for all xml data in one table

example

Quote:

I want to rename 'id' to 'term_id'

so that my new xml data will be look like this

Quote:

This is my basic code which I used to rename XML tag from definision to definition .

Quote:

update term
set term = xmlquery('copy $new := $TERM
modify( for $j in $new/term/definision
return do rename $j as "definition")
return $new' );

Which part do I have to alter which code above to rename attributes.

Thank You.

n_i · #2 (**permalink**) 01-27-12, 07:43

Did you have a chance to look at examples in the manual, particularly the XPath notation for attributes?