| 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>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
