dbsql2xml

No table creation script for oracle following is the example create table invoice( id number, customerId number, total number(5,2) ) create table customer( id number, firstName varchar2(30), lastName varchar2(30), street varchar2(100), city varchar2(30) ); create table item( invoiceId number, item varchar2(30), productId number, quantity number, cost number(5,2) ) create table product( id number, name varchar2(100), price number(5,2) ); insert into invoice (id,customerId,total)values('10','1',20.09); insert into customer values('1','test','test','irving ','Dallas'); insert into item (invoiceId,item ,productId,quantity,cost)values(10,1,1,20,200); insert into product values('1','1',20.09); select invoice.id as "invoice.id", invoice.customerid as "invoice.customerid", invoice.total as "invoice.total", item.invoiceid as "item.invoiceid", item.item as "item.item", item.productid as "item.productid", item.quantity as "item.quantity", item.cost as "item.cost", product.id as "product.id", product.name as "product.name", product.price as "product.price", customer.id as "customer.id", customer.firstname as "customer.firstname", customer.lastname as "customer.lastname", customer.street as "customer.street", customer.city as "customer.city" from invoice, item, product, customer where invoice.id=item.invoiceid and item.productid=product.id and invoice.customerid=customer.id and invoice.id = 10 <?xml version="1.0" encoding="UTF-8" standalone="no"?><dbsql2xml><invoice><id>10</id><customerId>1</customerId><total>20.09</total><customer><id>1</id><firstName>Indranil</firstName><lastName>Nag</lastName><street>21A S***nta Pally</street><city>Barrackpore</city></customer><item><invoiceId>10</invoiceId><item>1</item><productId>1</productId><quantity>20</quantity><cost>200</cost><product><id>1</id><name>1</name><price>20.09</price></product></item></invoice></dbsql2xml>