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
Did you know?Explore Trending and Topic pages for more stories like this.

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,
No comments posted yet

Your Answer:

Login to answer
337 Like 42 Dislike
Previous forums Next forums
Other forums

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

double and single quotes in text fields acting up... help please
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t

PHP onsubmit in the form not going to the fuction.
I have a form through ‘onsubmit’ calling a function validation(). But not going to the

Different payment methods with different cross company requirements in F110
We are implementing SAP in a company in the shipping industry. They have the following requirement:<

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

MYSQL gen help
This is my Mysql gen. can anyone tell me why this echos

MID(networkset.networkid, 3, 3) AS &q

Need to write a cookie with a url var
Not sure if its possible, but I need to write a cookie with a url.

So this would write 2232 a

Fatal error: Call to a member function fetchrow() on a non-object in C:xamppht
okay i have this query and everytime i add `item_id`=? to it... it gives me the error in the title..

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash