Greg Watson

Examples of selecting data from a database to produce XML are not too difficult to find. A Google search or a visit to the XML section at your local bookstore will no doubt reveal several such examples. It can, however, be more difficult to locate examples of how to insert data from XML into a database. Even if you locate such examples, it can be a challenge (to say the least) to adapt them to large XML files in which the data you need resides in a selected number of elements nested several levels deep within the file. This article illustrates how to use XSLT to generate SQL, which can then be loaded into an Oracle database using Unix shell scripts. For the purpose of illustrating the concept, the example given is relatively short and straightforward, but the method used in this article could easily be adapted to more complex projects. Furthermore, although this arti... (more)

Using XML Schemas and DTDs Together

XML Schemas are quickly becoming the industry standard that Document Type Definitions (DTDs) used to be. Much has been written about the advantages of XML Schemas over DTDs. Indeed, Schemas do offer advantages. However, with all the focus on the need to transition from DTDs to Schemas, it seems that little attention has been paid to how XML Schemas and DTDs can be used together. This article focuses on how to validate an XML document against an XML Schema and a DTD at the same time. Additionally, the article focuses on how to transition from using DTDs exclusively to using both ... (more)