In Part 1 of last issue’s article entitled In SQL: Using XML to Link Below the Root I described how ANSI SQL can transparently integrate native XML, and do it at a full hierarchical level that ...

A light-weight, simple and fast library to generate dynamic sql query from XML based on Java. The goal of this library is to help Java developers easily write sql queries without painfully ...

Published in TDAN.com April 2004 Introduction SQL/XML integration is in a mess today. Every SQL vendor’s XML support is proprietary and still does not integrate seamlessly, fully, or satisfactorily.

I blogged previously on the ease of use of GroovySql, which is Groovy‘s easy-to-use JDBC-based data access approach. In another blog post, I covered the utility of OracleXMLQuery, a class which easily ...

While designing large databases, one of the most commonly done things to incorporate future additions to the data fields is, adding a number of generic fields that can later be used as additional data ...

Abstract: Most business data are stored in relational database systems, and SQL (Structured Query Language) is used for data retrieval and manipulation. With XML (Extensible Markup Language) rapidly ...

This blog will show you how to create an xml from sql query having sql data. Write down the followng query to generate xml:- WITH XMLNAMESPACES ('http://www.dossia ...