Hi,
I have XML:
<list>
<product>
<availabilityCount>41.0000</availabilityCount>
<indexCatalogue>PR01</indexCatalogue>
<attributes>
<attribute eid="80140">
<name> width </name>
<value>100</value>
</attribute>
<attribute eid="80121">
<name>Height</name>
<value>17</value>
</attribute>
</attributes>
</product>
<product>
<availabilityCount>40.0000</availabilityCount>
<indexCatalogue>PR02</indexCatalogue>
<attributes>
<attribute eid="80140">
<name> width </name>
<value>120</value>
</attribute>
<attribute eid="80121">
<name>Height</name>
<value>27</value>
</attribute>
</attributes>
</product>
</list>
How to read attributes with APEX_DATA_PARSER.parse?
Now i have only:
select b.*
from table pl,
table(APEX_DATA_PARSER.parse(
p_content => pl.file_clob,
P_FILE_NAME => pl.file_name
)
) b
results:
LINIE NUMBER | COL001 | COL002 | COL003 | COL004 ...
1 41.0000 PR01 null null
2 40.0000 PR02 null null
i need acces to attributes with and height...