PLSQL: create XML from “hierarchical” table

[jaconi]

I have a table like this:\[code\]id | id_parent | tag_name0 | | TRANSACTION1 | 0 | NAME2 | 0 | ADDRESS3 | 2 | CITY\[/code\]and so on.I want to create an xml structure with it so I'll have something like this:\[code\]<TRANSACTION> <NAME /> <ADDRESS> <CITY /> </ADDRESS></TRANSACTION>\[/code\]I found some interesting features but I didn't find what I need...PS: I don't need a "real" XML, the result structure can be even a varchar2 (but it could become very big) or a clob.