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

change text color with a jQuery code
Hihow can I change the text in a asp:TextBox to a different color when I start typing using jQuery?I

UDP server recvfrom() always returns -1? :(
Hello all,
I am getting a very strange error in my code :( I am writing a server application in C

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

Printer configuration
Hi All,
Suppose one of the user deleted the printer settings unfortunatly ,then what is the pro

Undefined index: username HELP NEWBIE
I am trying a simple login/logout for my website. It works well with checking if the username exists

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

foreach result into a single variable
Hi,

I have this code...

Code: [Select]foreach ($_POST['Interests'] as $interest =&

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

Warning: session_start() headers already sent error - Driving me Nuts!
I am trying my sister in laws site and I keep getting an error with my coding. I am more of a design

session variable problem
Session variable is not working in Fire fox i am getting null value but it is working fine in IE.