(Chris Eaton) In DB2 v8 there was a new command delivered called the RECOVER command. This command combines the restore and roll forward commands into a single statement so that you can say RECOVER DATABASE db_name TO point_in_time
Author: SSWUG Research
Using a PL/SQL Table in SQL
(Lewis R Cunningham) A friend of mine called a few days ago with a question. He wanted to populate a PL/SQL table and use it to compare to some other data via a NOT IN subquery. He was having a problem getting the data into the nested table and wasn’t sure how to access it from SQL after he did.
SQL Server 2005 Integration Services – Performance – Part 30
(Marcin Policht) Throughout our coverage of SQL Server 2005 Integration Services, we have been primarily concerned with newly introduced and improved features, spending considerably less time discussing its performance advantages over Data Transformation Services. However, it is important to point o
MySQL Federated Tables: The Missing Manual
(Giuseppe Maxia) One of the most exciting features introduced in MySQL 5 is the federated engine. The ability to access data from a remote server without the constraints of replication tickles every programmer’s fancy.
The Java XML Validation API
(Elliotte Rusty Harold) Validation is a powerful tool. It enables you to quickly check that input is roughly in the form you expect and quickly reject any document that is too far away from what your process can handle. If there’s a problem with the data, it’s better to find out earlier than later.
Installing Oracle Application Server 10g Release 3 on Linux x86
(John Smiley) The guide provides a walkthrough of installing Oracle Application Server 10g Release 3 on commodity hardware for the purpose of evaluation. If you are new to Linux and/or Oracle, this guide is for you. It starts with the basics and walks you through an installation of Oracle Applicati
Using XTags to Add XSLT Transformations to Your JSP Web Applications
(Deepak Vohra) Today’s applications often use XML technology to represent and transfer structured data. You can display the data in an XML document as HTML by applying an XSLT stylesheet transformation to the XML data. In a Java application, you perform the XML-to-HTML transformation by writing code
Creating an Ajax Search Widget
(Jeremy McPeak) The most widely used function of the Web is searching. It’s not even an option; if you want to find any information, the search engines of the Web are the places you have to go to.
Oracle Refreshes PeopleSoft CRM Software
(Rick Whiting) Looking to keep its acquired PeopleSoft customers within the Oracle fold, Oracle is shipping PeopleSoft Enterprise CRM 9, a new release of the acquired vendor’s customer relationship management application.
Work with VB.NET’s ArrayList methods and properties
(Irina Medvinskaya) The ability to use collections is important in any language and practical for any application. Collections allow you to manage groups of objects. In this article, I’ll look at how to use an ArrayList class, which provides basic functionality that is useful to most applications. I