Questions tagged [xmlelement]

45 questions
12
votes
2 answers

How to replace ' or any special character in when using XMLELEMENT Oracle

I have the below query. How to keep the apostrophe (') intact and not getting it replaced by &apos There are other characters also I want to handle like & SELECT RTRIM(XMLAGG(XMLELEMENT(E,'I''m'||':')).EXTRACT('//text()'),':') FROM…
Rajiv A
  • 941
  • 5
  • 14
  • 30
5
votes
2 answers

How do I change the order of XmlElements?

I have an XML that has various elements, but one of them named RowId, I'd like to move to the top of the respective XML array...essentially sorting the elements in my way. My below code can be copied/pasted for you to test with. What's the best way…
William YK
  • 1,025
  • 12
  • 26
3
votes
0 answers

XML tag replace

I need to replace with <sec-title> in the below XML code. but the result removed <named-content> tag from <title>. var parser, xmlDoc; var text = "<bookstore><book>" + "<title>Teting<named-content…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/dom" class="post-tag grid--cell" title="show questions tagged 'dom'" rel="tag">dom</a> <a href="../../questions/tagged/domparser" class="post-tag grid--cell" title="show questions tagged 'domparser'" rel="tag">domparser</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Nov 10 '19 at 07:20">asked Nov 10 '19 at 07:20</time> <a href="../../users/10727661/anoop-sankar" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/10727661.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Anoop Sankar" /> </a> <div class="s-user-card--info"> <a href="../../users/10727661/anoop-sankar" class="s-user-card--link">Anoop Sankar</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">619</li> <li class="s-award-bling s-award-bling__silver" title="5 silver badges">5</li> <li class="s-award-bling s-award-bling__bronze" title="16 bronze badges">16</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-76968324"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status answered-accepted"> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/76968324/escaping-colon-in-powershell-xmldocument-createelement" class="question-hyperlink">Escaping colon in PowerShell XmlDocument.CreateElement</a></h3> <div class="excerpt">I am trying to escape a colon in the CreateElement method. So for example I want to change the following: $node = $xmldoc.CreateElement("test:example") To give me a node that looks like this: <test:example> But I unfortunately only get…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/powershell" class="post-tag grid--cell" title="show questions tagged 'powershell'" rel="tag">powershell</a> <a href="../../questions/tagged/special-characters" class="post-tag grid--cell" title="show questions tagged 'special-characters'" rel="tag">special-characters</a> <a href="../../questions/tagged/xmldocument" class="post-tag grid--cell" title="show questions tagged 'xmldocument'" rel="tag">xmldocument</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Aug 24 '23 at 10:18">asked Aug 24 '23 at 10:18</time> <a href="../../users/12309077/john" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/12309077.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="John" /> </a> <div class="s-user-card--info"> <a href="../../users/12309077/john" class="s-user-card--link">John</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">52</li> <li class="s-award-bling s-award-bling__bronze" title="8 bronze badges">8</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-72644090"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status answered-accepted"> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/72644090/unable-to-get-element-in-xml" class="question-hyperlink">Unable to get element in XML</a></h3> <div class="excerpt"><?xml version="1.0" encoding="utf-8"?> <serv:message xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:serv="http://www.webex.com/schemas/2002/06/service" xsi:schemaLocation="http://www.webex.com/schemas/2002/06/service…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/c#" class="post-tag grid--cell" title="show questions tagged 'c#'" rel="tag">c#</a> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/xmlnode" class="post-tag grid--cell" title="show questions tagged 'xmlnode'" rel="tag">xmlnode</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jun 16 '22 at 10:04">asked Jun 16 '22 at 10:04</time> <a href="../../users/1531290/sunil20000" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/1531290.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="sunil20000" /> </a> <div class="s-user-card--info"> <a href="../../users/1531290/sunil20000" class="s-user-card--link">sunil20000</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">356</li> <li class="s-award-bling s-award-bling__silver" title="3 silver badges">3</li> <li class="s-award-bling s-award-bling__bronze" title="16 bronze badges">16</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-70036494"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/70036494/how-to-create-a-xml-file-with-several-elements-inside-an-element-through-excel" class="question-hyperlink">How to create a XML file with several elements inside an element through Excel?</a></h3> <div class="excerpt">I need to create a xml file where I have this structure: <term name="example 1"> <customAttributes> <customAttributeValue customAttribute="xyz"> <customAttributeReferences> …</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/excel" class="post-tag grid--cell" title="show questions tagged 'excel'" rel="tag">excel</a> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/vba" class="post-tag grid--cell" title="show questions tagged 'vba'" rel="tag">vba</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Nov 19 '21 at 14:36">asked Nov 19 '21 at 14:36</time> <a href="../../users/17457585/gomes-36" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/17457585.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="gomes_36" /> </a> <div class="s-user-card--info"> <a href="../../users/17457585/gomes-36" class="s-user-card--link">gomes_36</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">11</li> <li class="s-award-bling s-award-bling__bronze" title="2 bronze badges">2</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-69496935"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status "> <strong>0</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/69496935/how-to-set-the-element-name-programmatically-in-a-list-xml-serialization-in-c" class="question-hyperlink">How to set the element name programmatically in a list (xml serialization in c#)?</a></h3> <div class="excerpt">I have to write some xml files which are all similar and simple(no nested elements, not many attributes), like this: <example> <data1>something1</data1> <data2 name="ex">something2</data2> <data3>something3</data3> ... </example> For the…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/c#" class="post-tag grid--cell" title="show questions tagged 'c#'" rel="tag">c#</a> <a href="../../questions/tagged/xml-serialization" class="post-tag grid--cell" title="show questions tagged 'xml-serialization'" rel="tag">xml-serialization</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Oct 08 '21 at 13:48">asked Oct 08 '21 at 13:48</time> <a href="../../users/14014661/iamuser" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/14014661.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="IAmUser" /> </a> <div class="s-user-card--info"> <a href="../../users/14014661/iamuser" class="s-user-card--link">IAmUser</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">78</li> <li class="s-award-bling s-award-bling__bronze" title="5 bronze badges">5</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-66904680"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/66904680/how-to-deserialize-xml-to-c-object-using-xml-attributes" class="question-hyperlink">How to Deserialize XML to C# Object using XML attributes</a></h3> <div class="excerpt">Worked with Json until now. Now I get an XML as data source and I would like to Deserialize it into C# objects using the XML attributes. The problem, as I see it is that I would like to serialize the XML only from MSGData - so I set the DOCUMENT as…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/c#" class="post-tag grid--cell" title="show questions tagged 'c#'" rel="tag">c#</a> <a href="../../questions/tagged/xml-deserialization" class="post-tag grid--cell" title="show questions tagged 'xml-deserialization'" rel="tag">xml-deserialization</a> <a href="../../questions/tagged/xml-attribute" class="post-tag grid--cell" title="show questions tagged 'xml-attribute'" rel="tag">xml-attribute</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Apr 01 '21 at 12:38">asked Apr 01 '21 at 12:38</time> <a href="../../users/6721134/guy-e" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/6721134.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Guy E" /> </a> <div class="s-user-card--info"> <a href="../../users/6721134/guy-e" class="s-user-card--link">Guy E</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">1,775</li> <li class="s-award-bling s-award-bling__gold" title="2 gold badges">2</li> <li class="s-award-bling s-award-bling__silver" title="27 silver badges">27</li> <li class="s-award-bling s-award-bling__bronze" title="55 bronze badges">55</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-66795170"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/66795170/how-to-handle-multiple-xml-api-response-results-with-go" class="question-hyperlink">How to handle multiple xml API response results with go?</a></h3> <div class="excerpt">To handle a xml API response result, need to catch multiple cases. For a success case and a failure case, I can define 2 struct to handle both of them. The source as: go playground. If the response data has many results, and they don't have the same…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/api" class="post-tag grid--cell" title="show questions tagged 'api'" rel="tag">api</a> <a href="../../questions/tagged/go" class="post-tag grid--cell" title="show questions tagged 'go'" rel="tag">go</a> <a href="../../questions/tagged/struct" class="post-tag grid--cell" title="show questions tagged 'struct'" rel="tag">struct</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Mar 25 '21 at 07:48">asked Mar 25 '21 at 07:48</time> <a href="../../users/15279606/realworld" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/15279606.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="realworld" /> </a> <div class="s-user-card--info"> <a href="../../users/15279606/realworld" class="s-user-card--link">realworld</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">159</li> <li class="s-award-bling s-award-bling__silver" title="2 silver badges">2</li> <li class="s-award-bling s-award-bling__bronze" title="10 bronze badges">10</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-65010254"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status answered-accepted"> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/65010254/when-converting-an-xml-document-to-an-array-in-php-is-there-a-way-to-convert-i" class="question-hyperlink">When converting an XML document to an Array in php, is there a way to convert it back and to save it as an XML file where attributes are elements?</a></h3> <div class="excerpt">I am trying to read an XML file in PHP, edit some values and save it back. I do it by opening the XML file in php. I then convert it using SimpleXML into an array. After doing the manipulation needed, I am struggling in returning that array into the…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/php" class="post-tag grid--cell" title="show questions tagged 'php'" rel="tag">php</a> <a href="../../questions/tagged/arrays" class="post-tag grid--cell" title="show questions tagged 'arrays'" rel="tag">arrays</a> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/simplexml" class="post-tag grid--cell" title="show questions tagged 'simplexml'" rel="tag">simplexml</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Nov 25 '20 at 17:55">asked Nov 25 '20 at 17:55</time> <a href="../../users/9639703/yan-ming-hu" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/9639703.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Yan Ming Hu" /> </a> <div class="s-user-card--info"> <a href="../../users/9639703/yan-ming-hu" class="s-user-card--link">Yan Ming Hu</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">13</li> <li class="s-award-bling s-award-bling__bronze" title="2 bronze badges">2</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-64128384"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status "> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/64128384/how-do-i-call-getchild-itemcost-currencyid-gbp-ns-getvalue-from-xml-response-i" class="question-hyperlink">How do I call `getChild('ItemCost currencyID="GBP"', NS).getValue()` from XML Response in Google Script</a></h3> <div class="excerpt">I have no problems with getting standard elements from an XML Response like getChild('BuyerEmail', NS).getText()but if there is extra data at the end like this getChild('ItemCost currencyID="GBP"', NS).getValue() then my code fails with a NUL. Its…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/api" class="post-tag grid--cell" title="show questions tagged 'api'" rel="tag">api</a> <a href="../../questions/tagged/google-apps-script" class="post-tag grid--cell" title="show questions tagged 'google-apps-script'" rel="tag">google-apps-script</a> <a href="../../questions/tagged/xml-parsing" class="post-tag grid--cell" title="show questions tagged 'xml-parsing'" rel="tag">xml-parsing</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Sep 29 '20 at 22:17">asked Sep 29 '20 at 22:17</time> <a href="../../users/14283247/razz" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/14283247.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Razz" /> </a> <div class="s-user-card--info"> <a href="../../users/14283247/razz" class="s-user-card--link">Razz</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">43</li> <li class="s-award-bling s-award-bling__bronze" title="7 bronze badges">7</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-62240864"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status "> <strong>0</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/62240864/xmlelement-group-of-attributes" class="question-hyperlink">XMLELEMENT group of attributes</a></h3> <div class="excerpt">we are able to generate the XML structure shown below, where the data is linear with no grouping with respect to the models. <transaction> <header> <trantype>siv</trantype> <options>ModelMasterEdit</options> </header> …</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/sql" class="post-tag grid--cell" title="show questions tagged 'sql'" rel="tag">sql</a> <a href="../../questions/tagged/grouping" class="post-tag grid--cell" title="show questions tagged 'grouping'" rel="tag">grouping</a> <a href="../../questions/tagged/xml-attribute" class="post-tag grid--cell" title="show questions tagged 'xml-attribute'" rel="tag">xml-attribute</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jun 07 '20 at 04:31">asked Jun 07 '20 at 04:31</time> <a href="../../users/13697804/samir-das" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/13697804.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Samir Das" /> </a> <div class="s-user-card--info"> <a href="../../users/13697804/samir-das" class="s-user-card--link">Samir Das</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">11</li> <li class="s-award-bling s-award-bling__bronze" title="1 bronze badges">1</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-60035612"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status answered-accepted"> <strong>1</strong> answer </div> </div> </div> <div class="summary"> <h3><a href="../../questions/60035612/getting-annotation-values-from-xmlelement-in-a-java-class" class="question-hyperlink">Getting annotation values from @XMLElement in a java class</a></h3> <div class="excerpt">I am trying to get the @XMLElement annotations from a java class that I have, basically trying to make a map of variables where the annotation is required: true. However it prints out nothing. I have a java class that has the following…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/java" class="post-tag grid--cell" title="show questions tagged 'java'" rel="tag">java</a> <a href="../../questions/tagged/annotations" class="post-tag grid--cell" title="show questions tagged 'annotations'" rel="tag">annotations</a> <a href="../../questions/tagged/jaxb" class="post-tag grid--cell" title="show questions tagged 'jaxb'" rel="tag">jaxb</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Feb 03 '20 at 08:35">asked Feb 03 '20 at 08:35</time> <a href="../../users/3636602/user3636602" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/3636602.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="user3636602" /> </a> <div class="s-user-card--info"> <a href="../../users/3636602/user3636602" class="s-user-card--link">user3636602</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">73</li> <li class="s-award-bling s-award-bling__silver" title="1 silver badges">1</li> <li class="s-award-bling s-award-bling__bronze" title="10 bronze badges">10</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-58444431"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status answered-accepted"> <strong>2</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/58444431/convert-listagg-to-xmlagg" class="question-hyperlink">Convert LISTAGG to XMLAGG</a></h3> <div class="excerpt">I have a query using LISTAGG function that need to convert to XMLAGG in order to handle string concatenation more than 4000 characters: LISTAGG(NAME || INPUT || DESC || ' ' || '<cm>' || DATA || '</cm>', CHR(13)||CHR(10)) WITHIN GROUP(ORDER BY NAME)…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/oracle" class="post-tag grid--cell" title="show questions tagged 'oracle'" rel="tag">oracle</a> <a href="../../questions/tagged/string-concatenation" class="post-tag grid--cell" title="show questions tagged 'string-concatenation'" rel="tag">string-concatenation</a> <a href="../../questions/tagged/listagg" class="post-tag grid--cell" title="show questions tagged 'listagg'" rel="tag">listagg</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Oct 18 '19 at 05:23">asked Oct 18 '19 at 05:23</time> <a href="../../users/2102665/user2102665" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/2102665.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="user2102665" /> </a> <div class="s-user-card--info"> <a href="../../users/2102665/user2102665" class="s-user-card--link">user2102665</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">429</li> <li class="s-award-bling s-award-bling__gold" title="2 gold badges">2</li> <li class="s-award-bling s-award-bling__silver" title="11 silver badges">11</li> <li class="s-award-bling s-award-bling__bronze" title="26 bronze badges">26</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="mln24"> <div class="question-summary" id="question-summary-56962323"> <div class="statscontainer"> <div class="stats"> <div class="vote"> <div class="votes"> <span class="vote-count-post"><strong>1</strong></span> <div class="viewcount">vote</div> </div> </div> <div class="status answered-accepted"> <strong>2</strong> answers </div> </div> </div> <div class="summary"> <h3><a href="../../questions/56962323/how-to-select-particular-level-node-from-xmldocument" class="question-hyperlink">How to select particular level node from xmldocument</a></h3> <div class="excerpt">XmlDocument is looks as below, want to select the one node that is under <soap:Body> so, any first node under path: soap:Envelope/soap:Body/ so, at below example, need to select "DynamicNode" element (But, It should not be through "DynamicNode" as…</div> <div class="grid ai-start jc-space-between fw-wrap"> <div class="grid gs4 fw-wrap tags "> <a href="../../questions/tagged/c#" class="post-tag grid--cell" title="show questions tagged 'c#'" rel="tag">c#</a> <a href="../../questions/tagged/xml" class="post-tag grid--cell" title="show questions tagged 'xml'" rel="tag">xml</a> <a href="../../questions/tagged/c#-4.0" class="post-tag grid--cell" title="show questions tagged 'c#-4.0'" rel="tag">c#-4.0</a> <a href="../../questions/tagged/xmldocument" class="post-tag grid--cell" title="show questions tagged 'xmldocument'" rel="tag">xmldocument</a> <a href="../../questions/tagged/xmlelement" class="post-tag grid--cell" title="show questions tagged 'xmlelement'" rel="tag">xmlelement</a> </div> <div class="started mt0"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Jul 10 '19 at 01:34">asked Jul 10 '19 at 01:34</time> <a href="../../users/2182021/dsi" class="s-avatar s-avatar__32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/2182021.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="dsi" /> </a> <div class="s-user-card--info"> <a href="../../users/2182021/dsi" class="s-user-card--link">dsi</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">3,199</li> <li class="s-award-bling s-award-bling__gold" title="12 gold badges">12</li> <li class="s-award-bling s-award-bling__silver" title="59 silver badges">59</li> <li class="s-award-bling s-award-bling__bronze" title="102 bronze badges">102</li> </ul> </div> </div> </div> </div> </div> </div> </div> <div class="s-pagination pager fr"> <div class="s-pagination--item is-selected">1</div> <a class="s-pagination--item" href="../../questions/tagged/xmlelement_page=2" rel="" title="Go to page 2">2</a> <a class="s-pagination--item" href="../../questions/tagged/xmlelement_page=3" rel="" title="Go to page 3">3</a> <a class="s-pagination--item" href="../../questions/tagged/xmlelement_page=2" rel="next" title="Go to page 2"> Next</a> </div> </div> </div> </div> </div> <script src="../../static/js/stack-icons.js"></script> <script src="../../static/js/fromnow.js"></script> </body> </html>