(Steve Callan) Oracle provides quite an array of functions when it comes to manipulating data via SQL. The Oracle9i SQL Reference guide (for release 2) lists five categories of SQL functions, with each category containing one or more functions within a category. The major functions are single-row, a
Other News
DB2 Database and Tivoli Storage Manager
(Marin Komadina) My first DB2 article, “Who needs incremental delta backup” published on January 29, 2003 was an introduction to the DB2 backup and recovery technology on the SUN Solaris platform. Since then, I have been asked many times to write on some very interesting topics that are not covered
Connect to DB2 from Microsoft .NET
(Sreejumon) Most of the retail applications are still running in legacy systems like AS/400, Mainframe etc. If you are planning to migrate the entire application (or any modules) to Microsoft .NET, migration of the existing data will be the bottleneck (since there can be terra bytes of data, synchro
XML Matters: XML for word processors
(David Mertz) Beyond a few abandoned or incomplete efforts, three word processors are now available in actively maintained states. All do an excellent job as word processors; all provide a variety of useful import/export capabilities — including the widely used, but proprietary, Microsoft Word form
Migrating Applications from Microsoft SQL Server to Oracle9i Database
The purpose of this document is to help you migrate your applications when you are migrating the underlying database from Microsoft SQL Server to Oracle9i Database. Most of the issues encountered when migrating applications to use an Oracle9i Database are related to database incompatibility. This pa
XQuery Tricks and Traps
(Jason Hunter) To help you better understand how to correctly form XQuery queries, I focus in this article on important but tricky and commonly misunderstood aspects of the XQuery language. I warn you: Things will get hairy beyond this point. But it’s better to have fair warning of the complex parts
MDX in Analysis Services: Optimizing MDX: Caching and Other Considerations
(William Pearson) This is the twelfth tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services (“Analysis Services,”); our primary focus is the manipulation
Review of ApexSQL Log
(Brian Kelley) ApexSQL Log is a new product from ApexSQL, formerly LockwoodTech Software. ApexSQL Log provides the capability to passively review the contents of database transaction logs and transaction log backups. For databases prepared beforehand (more on this under installation), ApexSQL Log gi
Installing Oracle Database 10g on Red Hat Enterprise Linux AS 3 and 2.1, and on Red Hat 9
(Werner Puschitz) The following procedure is a step-by-step guide (Cookbook) with tips and information for installing Oracle Database 10g on Red Hat Linux. Oracle10g is the easiest Oracle on Linux installation so far.
Creating Valid XML Documents: DTDs
The past couple days have prepared you for what’s coming up now—the creation of valid XML documents. Unlike with HTML, where a browser can check HTML because it knows all about legal HTML, you create your own markup in XML, which means that an XML processor can’t check your markup unless you let it