OraFAQ Forum: JDeveloper, Java & XML » Extract XML data into columns

Home » Developer & Programmer » JDeveloper, Java & XML » Extract XML data into columns

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Extract XML data into columns [message #677503]

Tue, 24 September 2019 00:50

ramya29p
Messages: 146
Registered: November 2007
Location: Chennai

Senior Member

Hi All,
I want to extract the XML data into separate column.

Below is the XML . I want to display each series code as a column and its corresponding value.


<PivotSet>
<item>
<column name = "SERIES_CODE">FY1</column>
<column name = "VAL">3.505331702434</column>
</item>
<item>
<column name = "SERIES_CODE">FY2</column>
<column name = "VAL">3.357474212727</column>
</item>
</PivotSet>

Expected output is

FY1       FY2
3.5053    3.3574

Report message to a moderator

[Message index]

		Extract XML data into columns By: ramya29p on Tue, 24 September 2019 00:50
		Re: Extract XML data into columns By: Michel Cadot on Tue, 24 September 2019 01:26
		Re: Extract XML data into columns By: ramya29p on Tue, 24 September 2019 01:40
		Re: Extract XML data into columns By: Michel Cadot on Tue, 24 September 2019 01:52
		Re: Extract XML data into columns By: Michel Cadot on Tue, 24 September 2019 03:42
		Re: Extract XML data into columns By: ramya29p on Tue, 24 September 2019 23:50
		Re: Extract XML data into columns By: Louise M Marquez on Tue, 14 January 2020 23:50

Previous Topic:	If condition for LOV columns
Next Topic:	ORA-29532: Java call terminated by uncaught Java exception: java.lang.AbstractMethodError

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:15:51 CDT 2024