Home » Developer & Programmer » JDeveloper, Java & XML » Ho to create hierarchical XML using PL/SQL?
Ho to create hierarchical XML using PL/SQL? [message #91918] Mon, 18 August 2003 06:00
Andrei
Messages: 2
Registered: July 2003
Junior Member
Ho to create hierarchical XML using PL/SQL?

I have a table EMP;

EMP has fields:

EMP_ID,
NAME,
MANAGER;

How to create hierarchical XML from the table's EMP data?

The XML format must be like that:
<emp_list>
<emp id="1">
<name>John</name>
<emp_list>
<emp id="2">
<name>Mike</name>
</emp>
<emp id="4">
<name>Oscar</name>
<emp_list>
<emp id="5">
<name>Mike</name>
</emp>
</emp_list>
</emp>
</emp_list>
</emp>
<emp id="3">
<name>Jane</name>
</emp>
<emp_list>
Previous Topic: JDeveloper 9.0.2 problem when using debugger
Next Topic: Error Processing Resource
Goto Forum:
  


Current Time: Tue Jul 27 11:11:55 CDT 2021