I have XML column like this
<c179 m="28">Test Data</c179><c179 m="28" s="2">Test Data 2</c179>
I want to extract data ("Test Data" and "Test Date 2") using query in oracle sql developer. (extractvalue or something)
SELECT extractValue(columnName,'/row/c179[position()=1]'),
extractValue(columnName,'/row/c179[position()=2]')
FROM table_Name
Currently I am trying like this and not working.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…