Questions tagged [updatexml]
30 questions
6
votes
1 answer
Updating Oracle XMLType Column Content For a Given Value
I have a table, SECTION_ANSWER, in an Oracle 11g database which has an XMLType column. The XML is pretty simple, it follows the structure:
Green
…
The Gilbert Arenas Dagger
- 12,071
- 13
- 66
- 80
3
votes
3 answers
How do I add an attribute to xml contained within a CLOB in an Oracle database?
How do I add an attribute to xml contained within a CLOB in an Oracle database? I can use the UpdateXML function to update an existing attribute but it will not add one.
benstpierre
- 32,833
- 51
- 177
- 288
2
votes
1 answer
how to update xml file from another xml file dynamically?
I would like to update an xml file from another xml file.I have used an xml file as shown below:
one.xml
prasad.gai
- 2,977
- 10
- 58
- 93
2
votes
2 answers
Oracle: how to use updateXML to update multiple nodes in a document?
I can write:
update my_table
set xml = updateXML(xml, '/a/b', '1')
where document_id = 123
Now what if in the same update query I also want to set /a/c to 2 (in addition /a/b to 1)? I am tempted to write:
update my_table
set
xml =…
avernet
- 30,895
- 44
- 126
- 163
2
votes
2 answers
Update nodes detail in XML using XSLT
I want to update some nodes in XML using XSLT. Like contact detail and Email.
Currently I am using command like:
…
user3345354
- 95
- 4
2
votes
1 answer
Oracle updateXml "less than sign" as text
I have xml document
a<b
and I want to update it to
a<b or c>d
using updateXML statement.
Executing
select updateXML(xmltype('a<b
Kotodid
- 879
- 6
- 18
1
vote
1 answer
UPDATEXML when there is namespaces
I have to update value in XML:
Morticia A. Addams
- 363
- 1
- 7
- 19
1
vote
1 answer
Insert element in XML using XSLT xsl:for-each
I want to insert some elements in middle of xml and remove some elements in the XML.
Please find below the XSLT using to convert the xml.
Mohan
- 71
- 2
- 12
1
vote
1 answer
Update XML nodes when there are multiple matches in MySQL
I need to remove nodes from XML.
I try to use UpdateXML function.
For example removing node C:
SELECT UpdateXML('b_valuec_value1 ', '/A/B/C', '')
Result:
'b_value'
But when in XML there are multiples matches,…
Evgenia
- 335
- 2
- 12
1
vote
1 answer
Have Excel Row Saved in SQL Server Column (XML data type). How Do I update a particular Cell value?
I have a row of excel data (i.e. several cells from an excel sheet) saved into a SQL Server table, in a column that is of datatype XML.
I need to update the value, in a particular cell, in this data saved in the XML column, with a new value that is…
Shiva
- 20,575
- 14
- 82
- 112
1
vote
1 answer
Replace Particular XML tag with NULL value in Oracle SQL
I have columns as VALUE in DUMMY table with type XMLTYPE.
It contains:
802
902
I need to replace it with NULL…
YLG
- 855
- 2
- 14
- 36
1
vote
1 answer
Oracle: how to add a text node into an existing element
In Oracle, you can write:
update t
set xml = updateXML(xml, '/a/b/text()', 'gaga')
This works only if you already have some text in the element. How to update the document and "add some text" in if the document in the database looks…
avernet
- 30,895
- 44
- 126
- 163
1
vote
1 answer
Update xml tag in a CLOB column in Oracle
I have this xml value in a CLOB column in Oracle 11g:
M
MAR
VAN HALL
…
user1037527
- 49
- 1
- 2
- 5
1
vote
1 answer
PL/SQL: Using a variable in UPDATEXML function
I need to update an XML node that contains a specific number. My query works if I hard code in the number (see figure 1), but I would like to make this dynamic by passing through a variable that contains a string (variableToBeReplaced). I currently…
aflores2
- 11
- 1
0
votes
1 answer
Update xml element value in Oracle
Having a XMLTYPE column in an Oracle table, I would like to update the values of some xml elements using UpdateXML method but I have troubles doing so because of a namespace which is applied on an xml element which is not parent. The xml structure…
axl g
- 612
- 2
- 9
- 20