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 change www in url with a specified name
Hi
I'm trying to change the url http://www.sitename.com/apparels to something like below
http:

Stats of viewers
Hello. I have a website in php and people can login. I want to make an admin control panel where u c

Multidimensional Array into an Html table, help!
Hello all, I am new to HTML/PHP so any help would be great.

I have a multidimensional array f

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Inserting 100x and 100y coordinates in mysql table - easy
Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y in

PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html

parsing error
can anyone explain this syntax error:

Parse error: syntax error, unexpected T_IF

The e

Batch Session SM35 stuck in status 'in Background
Hi Experts,

I am facing a problem with Batch Input session SM35.

The batch se

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi

Redistributing dependent dlls
Hai all ,

I have created an application in VC++ using VS2008 in a development machine which r