(Lewis R Cunningham) I started working on a task for a project and decided that there were some very good properties that I could use to help me teach people PL/SQL and XML. I expanded a bit on the idea and ended up with a scripting language, implemented in XML, that can be passed into a PL/SQL proc
Author: SSWUG Research
Practical XML Usage
(Gaidar Magdanurov) A common task for a developer working for a large business is to build and connect applications that process data. The data could be generated by an application which was working in a production environment for years and sometimes it is really difficult to connect one application
Understanding clustering index behavior on partitioned tables
Clustering indexes offer the same benefits for partitioned tables as they do for regular tables. However, care must be taken in choosing a clustering index with regards to the table partitioning key definitions.
Preparing for the Future: Best Practice Strategies for successful Oracle Upgrades
Register for this complimentary Webcast to learn how IBM can assist in getting your applications current, while keeping your business ahead of the curve. (R, webcast)
Debugging PL/SQL from .NET
(Mark A. Williams) Debugging PL/SQL code in Microsoft Visual Studio is as easy as debugging native .NET code, thanks to the PL/SQL debugger in Oracle Developer Tools for Visual Studio .NET (ODT). This column demonstrates how to set up PL/SQL debugging in ODT and how to create and step through PL/SQL
DB2 UDB V9.1SQL Cookbook
(Graeme Birchall) This Cookbook is for DB2 UDB for Windows, Unix, Linux, etc. It is not suitable for z/OS or DB2 for AS/400. The SQL in these two products is somewhat different. (pdf)
Why only one primary key?
(Brian Peasland) Why is there only one primary key allowed in a table? Why not more than one? Even then you can have multiple unique and not null constraints defined on any number of columns. (R)
DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET
(Whei-Jen Chen, John Chun, Naomi Ngan, Rakesh Ranjan and Manoj K. Sardana) DB2 Express Edition for Community (DB2 Express-C) is a no charge data server for use in development and deployment. DB2 Express-C supports a full range of APIs, drivers, and interfaces for application development including PH
Stored procedures vs. dynamic SQL: When should you use each?
(Serdar Yegulalp) In the six years I’ve worked with SQL Server, there’s been an ongoing debate about whether stored procedures or dynamically-generated SQL strings are the better choice for certain jobs. (R)
SQL Server 2005 Service Broker Plays Well with Older Relatives
(Jeffrey Juday) SQL Server 2005 Service Broker (SSB) is an asynchronous messaging technology built into SQL Server. With SSB, you essentially get the power of messaging technologies like Microsoft Message Queue (MSMQ) combined with the relational database capabilities of SQL Server, all controlled w