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 ...

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 ...

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 ...

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 ...

Abstract: XML (extensible markup language) has become the standard of data description and exchanging in the Internet, and it will be the main form for storing Web data: SQL Server is the leading ...

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 ...