Books by Jim (Oracle Corporation Melton

Details SQL:1999's object facilities, including structured user-defined types, typed tables, user-defined routines, and routine invocation. Serving as a guide to this standard's practical application, this title focuses on the issues that matter to programmers who are connecting applications to databases.

Providing an introduction to SQL, this work describes practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design. It includes a tutorial on basic relational database concepts. It also presents an explanation of the differences between SQL-89 and SQL-92.

Intended for both novice and experienced SQL users, this work focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. It illustrates features and techniques with references to their own custom database, which can be downloaded from the companion Web site.

Helps managers and project leaders grasp how 'querying XML' fits into the larger context of querying and XML. This book provides a background from fundamental concepts (What is XML?) to data models (the Infoset, PSVI, XQuery Data Model), to APIs (querying XML from SQL or Java), and more.