How to form a xml form table with a single sql statement..?

Posted on 16th Feb 2014 07:03 pm by admin

Hi everyone,
I don't know if this is going to be a duplicate thread but i couldn't find one exactly like this. Let me explain the problem first --

we have a table say -- XML_TEMPLATE_DATA with data like ----- TABLE : XML_TEMPLATE_DATA ----- TAG_NAME TAG_ID NAMESPACE PARENT_TAG_ID ----------------- ----------- ------------------- ------------------------- ROOTTAG 1 m0 NULL TAG1 2 m1 1 TAG2 3 m1 1 TAG11 4 m11 2 TAG12 5 m12 2 TAG21 6 m21 3 TAG22 7 m12 3 there is another table XML_TAG_VALUES ---------- TABLE : XML_TAG_VALUES --------------- TAG_ID VALUE ------------ ---------- TAG11 VAL11 TAG12 VAL12 TAG21 VAL21 TAG22 VAL22

This is a common template for a XML. Now i we can generate a XML form this using pl/sql but can we generate a xml from these two tables
by a single sql statement.I tried a lot but couldn't come up with one!!

Thanks,

Your Answer:

Login to answer

Other forums

How to restrict the display of report variants
Hello All,

I want t know how to restrict the display of report variants.
I mean, whe

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

Comment Mod System Effects all rows...
Sorry if its confusing but here is whats going on: I have a table in a database called comments and

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

TinyMCE / Ajax Postback Problem
Hiya all,

I have a page which loads the TinyMCE editor. On the postback I obviously want to f

PHP XML extraction text
I would like to extract an xml text and have that text directly echo(print) out on my web page. Her

help with this code please?
Hello,

I am trying to build a remote upload script for my image hosting site.

I am usi

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

sendmail code suddenly not working
Hi Guys, I maintain 3 sites (including my own) I use the following code from a french webmaster that

Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop thro