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 |