Home » Developer & Programmer » JDeveloper, Java & XML » xml tree structure using Plsql
xml tree structure using Plsql [message #671427] Wed, 29 August 2018 05:09 Go to next message
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 Go to previous message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: Chat Box Implementation
Next Topic: Help with xmltable
Goto Forum:
  


Current Time: Sat Dec 14 18:01:57 CST 2019