By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
CUSTOMER_ID | ITEM_XML |
---|---|
1 | <items> <item>Apple</item> </items> |
2 | <items xmlns:xml="http://www.w3.org/XML/1998/namespace"> <item>Banana</item> </items> |
1 rows affected
1 rows affected
ITEM_XML |
---|
<items> <item xml:id="123" xmlns:xml="http://www.w3.org/XML/1998/namespace">Apple</item> </items> |
ITEM_XML |
---|
<items> <item xml:id="123" xmlns:xml="http://www.w3.org/XML/1998/namespace">Apple</item> </items> |
<items xmlns:xml="http://www.w3.org/XML/1998/namespace"> <item xml:id="456" xmlns:xml="http://www.w3.org/XML/1998/namespace">Banana</item> </items> |