add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
EXTRACT(XMLTYPE(COL1),'(/*[LOCAL-NAME()="CONSTANTINPUTPROPERTIES"][1])/VALUE/TEXT()')
0
null
null
null
XMLQUERY('(/*[LOCAL-NAME()="CONSTANTINPUTPROPERTIES"][1])/VALUE/TEXT()'PASSINGXMLTYPE(COL1)RETURNINGCONTENT)
0
null
null
null
XMLQUERY('(/*[LOCAL-NAME()=$VAR1][1])/VALUE/TEXT()'PASSINGXMLTYPE(COL1),'CONSTANTINPUTPROPERTIES'AS"VAR1"RETURNINGCONTENT)
0
null
null
null
XMLQUERY('(/*[LOCAL-NAME()=$VAR1][1])/VALUE[@XSI:TYPE="XSD:INT"]/TEXT()'PASSINGXMLTYPE(COL1),'CONSTANTINPUTPROPERTIES'AS"VAR1"RETURNINGCONTENT)
0
null
null
null
XMLQUERY('(/*[LOCAL-NAME()=$VAR1][1])/VALUE[@XSI:TYPE="ARRAYOFINT"]/INT/TEXT()'PASSINGXMLTYPE(COL1),'CONSTANTINPUTPROPERTIES'AS"VAR1"RETURNINGCONTENT)
null
01
null
null
XMLQUERY('(/*[LOCAL-NAME()=$VAR1][1])/VALUE[@XSI:TYPE="ARRAYOFBOOLEAN"]/BOOLEAN/TEXT()'PASSINGXMLTYPE(COL1),'CONSTANTINPUTPROPERTIES'AS"VAR1"RETURNINGCONTENT)
null
null
truetruetruetruetrue
null
XMLQUERY('(/*[LOCAL-NAME()=$VAR1][1])/VALUE[@XSI:TYPE="ARRAYOFDECIMAL"]/DECIMAL/TEXT()'PASSINGXMLTYPE(COL1),'CONSTANTINPUTPROPERTIES'AS"VAR1"RETURNINGCONTENT)
null
null
null
1.0000000000
XMLQUERY('(/*[LOCAL-NAME()=$VAR1][1])/VALUE/*/TEXT()'PASSINGXMLTYPE(COL1),'CONSTANTINPUTPROPERTIES'AS"VAR1"RETURNINGCONTENT)
null
01
truetruetruetruetrue
1.0000000000
ID N VALUE N VALUE N VALUE N VALUE
1 1 0 null null null null null null
2 1 null 1 0 null null null null
2 1 null 2 1 null null null null
3 1 null null null 1 true null null
3 1 null null null 2 true null null
3 1 null null null 3 true null null
3 1 null null null 4 true null null
3 1 null null null 5 true null null
4 1 null null null null null 1 1.0000000000
ID RESULT
1 0
2 0 1
3 true true true true true
4 1.0000000000