| xml tree structure using Plsql [message #671427] |
Wed, 29 August 2018 05:09  |
 |
SoujanyaSM
Messages: 3
Registered: April 2018
|
Junior Member |
|
|
Hi,
I have a requirement where I have to extract accounting hierarchies from database. This data is having parent and child relationship upto 9 child nodes with 1 to many relationship. For one node there may be N number of child nodes.
My end data may look like this -
<Parent_node>
<child_1_node>
<child_2_node>
<child_2.1_node>
<child_2.1.1_node>
<child_2.1.1.1_node>
</child_2.1_node>
</child_2._node>
<child_3_node></child3_node>
<child_4_node></child4_node>
.
.
.
Thanks in advance!
-Soujanya
[mod-edit: code tags added by bb]
[Updated on: Sat, 08 September 2018 16:20] by Moderator Report message to a moderator |
|
|
|
| Re: xml tree structure using Plsql [message #671428 is a reply to message #671427] |
Wed, 29 August 2018 05:31  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You do not understand how XML works.
The data MUST NOT in the node NAMES, they are INSIDE the nodes.
From your previous topic:
BlackSwan wrote on Mon, 23 April 2018 23:26
Welcome to this forum
Please READ and FOLLOW the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.
Also always post your Oracle version, with 4 decimals, as solution depends on it.
[Updated on: Wed, 29 August 2018 05:32] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
