Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

convert xml to relational data.

M Prasad-OracleSep 20 2018 — edited Sep 21 2018

I have below xml and wanted to convert it in relational data.

<?xml version='1.0' encoding='UTF-8' standalone='yes'?><methodResponse><params><param><value><array><data><value><struct><member><name>id</name><value><string>4</string></value></member><member><name>network_id</name><value><string>Management</string></value></member><member><name>port</name><value><string>1514</string></value></member><member><name>enabled</name><value><string>true</string></value></member></struct></value><value><struct><member><name>id</name><value><string>5</string></value></member><member><name>network_id</name><value><string>Management</string></value></member><member><name>port</name><value><string>1415</string></value></member><member><name>enabled</name><value><string>false</string></value></member></struct></value></data></array></value></param></params></methodResponse>

Result should as below.

ID NETWORK_ID PORT ENABLED

================================

4 Management 1514 true

5 Management 1415 false

Please provide pointer.

This post has been answered by mNem on Sep 20 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2018
Added on Sep 20 2018
7 comments
501 views