'How to delete more than one node with xml-query

with this code, I can remove one node (field_without_interest) of this xml element. But I would like to remove two nodes now( field_without_interest and PERSON_NUMBER). I have tried to place the for loop at differents places (You can see that in code. But I don't think it useful to for to write every attemps in stackoverflow) but to no avail.

SELECT XMLQUERY(
         'copy $NEWHTML := .
         modify (
           for $i in $NEWHTML/ROWSET/ROW/field_without_interest
           --for $j in $NEWHTML/ROWSET/ROW/PERSON_NUMBER
           return delete node $i--, node $j
         )
         return $NEWHTML'
         PASSING xmltype(
  '<?xml version="1.0"?> 
  <ROWSET> 
    <ROW>
      <PERSON_NUMBER>1000142</PERSON_NUMBER>
      <LOAN_1>25000</LOAN_1>
      <field_without_interest>f</field_without_interest>
    </ROW> 
    <ROW>
      <PERSON_NUMBER>1000142</PERSON_NUMBER>
      <LOAN_1>25000</LOAN_1>
    </ROW> 
  </ROWSET>'
)
         RETURNING CONTENT
       ).getStringVal() AS interested_elements
FROM   DUAL

code



Solution 1:[1]

Preferences > Editor > General > Code Folding > XML > XML tags: disable

screenshot

Solution 2:[2]

For Android Studio 4.0 or above

Goto Settings or Press (Ctrl + Alt + S)

And Navigate to Editor = > Code Folding

enter image description here

And uncheck the option XML tags enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 hata
Solution 2 Yousha Bin Arif