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

Secure FTP
Hi experts,
There is no SFTP action in MII workbench.
This means it needs developing custo

reorder sql query
ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_key

How to use Substr
I want to check for the word CATEGORY: inside a string which can be CATEGORY: ITEM
and remove the

Auto-populating dropdowns and multiple forms.
Here's what I have so far:

First drop down = select a state (works)
This populates the sec

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu

Downloading file (Headers)
I'm trying to make users download a file, but they must wait 60 seconds before it begins.

But

Inserting a check in checkbox from array value
Hello all,
I have a bit of code that works for a select option box, but does not work for my chec

Pre-Fill out a PHP form...??
This is for work actually (geek squad). We have to fill out this online php form at work over and ov

Retail terminologys not been altered after activing Retail System
Hi, All

After I active Retail System via TCode SWF5, the terms does not been changed, th

Parse error: syntax error, unexpected T_ELSEIF in /home/......html/item.php on l
I do not know what is wrong with this. Hope some one can help. I do nto want to post the entire site