Дано:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
SELECT xt.*
FROM XMLTABLE('/xml/conditionalFormatting'
PASSING XMLtype('<xml> <conditionalFormatting sqref="M29:P29 Q10:Q29 Q39:Q52 Q58:Q59 Q54:Q56 Q31:Q32 M31:O31 B31:G31 B33:L38">
<cfRule type="cellIs" dxfId="64" priority="13" operator="equal">
<formula>0</formula>
</cfRule>
</conditionalFormatting>
<conditionalFormatting sqref="T57 B57:Q57">
<cfRule type="cellIs" dxfId="63" priority="14" operator="equal">
<formula>0</formula>
</cfRule>
</conditionalFormatting>
<conditionalFormatting sqref="P4:Q4 Q3 P2 P73:Q965">
<cfRule type="cellIs" dxfId="62" priority="15" operator="equal">
<formula>0</formula>
</cfRule>
</conditionalFormatting>
<conditionalFormatting sqref="B37:C37">
<cfRule type="cellIs" dxfId="61" priority="16" operator="equal">
<formula>0</formula>
</cfRule>
</conditionalFormatting></xml>
')
COLUMNS
sqref VARCHAR2(32000) PATH '@sqref'
,all_node_content VARCHAR2(32000) PATH 'node()'
) xt;
Нужно: что во втором столбце выводился не ноль, а целиком всё содержимое узла conditionalFormatting в виде текста, т.е. для первой строки это:
1.
2.
3.
4.
<cfRule type="cellIs" dxfId="64" priority="13" operator="equal">
<formula>0</formula>
</cfRule>
sqrefall_node_contentM29:P29 Q10:Q29 Q39:Q52 Q58:Q59 Q54:Q56 Q31:Q32 M31:O31 B31:G31 B33:L38<cfRule type="cellIs" dxfId="64" priority="13" operator="equal"> <formula>0</formula> </cfRule>
как так сделать?
