(Steven Feuerstein) I have been writing PL/SQL code since 1990. This means I have churned out tens of thousands of lines of software, and most of it, I am certain, was poorly written and difficult to maintain. Fortunately, I have discovered that it is never too late to find—and follow—new paths
Other News
SQL Server Stored Procedure Basics
(Ken Henderson) Working from the assumption that the human brain learns by associating new data with what it already knows, we’ll spend this chapter building a base framework onto which we can assemble the knowledge conveyed by the remainder of the book. We’ll touch on the topics covered in the
Writing Better SQL Using Regular Expressions
A new feature of Oracle Database 10g vastly improves your ability to search and manipulate character data. (Alice Rischert) This feature, regular expressions, is a notation for describing textual patterns. It has long been available in many programming languages and a number of UNIX utilities. O
Adding Conflict Resolution Features to a Query Language for Database Federations
(Kai-Uwe Sattler, Stefan Conrad, and Gunter Saake) A main problem of data integration is the treatment of conflicts caused by different modeling of real-world entities, different data models or simply by different representations of one and the same object. During the integration phase these conflic
XSL Transformations (XSLT)
This specification defines the syntax and semantics of XSLT, which is a language for transforming XML documents into other XML documents. XSLT is designed for use as part of XSL, which is a stylesheet language for XML. In addition to XSLT, XSL includes an XML vocabulary for specifying formatting.
Dates in Oracle 8i and earlier versions
(Philip Greenspun) From version 9 onwards it is possible to represent points in time and time intervals using ANSI SQL data types such as timestamp and interval. We strongly recommend that you use the newly available ANSI data types when building new applications. Visit the main chapter on dates for
Unauthorized Access to Restricted Content in Oracle Files
A potential security vulnerability has been discovered in the Oracle Files component that ships with Oracle Collaboration Suite Release 1. A knowledgeable and malicious user of Oracle Files can potentially access restricted content. In the Oracle Files component that ships with Oracle Collaborat
DB2 UDB v8.1 Express: Initial Configuration and Rules of Thumb
(Fraser McArthur) The goal of this document is to give straight forward and easy to implement recommendations which can lead to a well-performing DB2 UDB V8 Express system. This document covers several easy-to-use utilities and provides some useful rules of thumb for database configuration.
Roadmap for Programming XML with the Pull-Model Parser in the .NET Framework
This article provides a roadmap for programming XML with the pull-model parser of the .NET Framework. To help with learning a Microsoft product or technology, roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and white papers.
How to Create Dynamic Table Names in SQL Server
If you need a temporary table to persist across non-nested stored procedures and then you want to drop the temporary table when you no longer need it, you can dynamically create permanent tables in your code. This article provides an example of this procedure.