(Meenakshi Thanikachalam) There are various ways to identify new or changed data in a data warehouse. One technique to determine the changes is to include a timestamp on each row in the operational system as the record is changed.The data extraction program then selects the new or changed source dat

(Jim Czuprynski) With Oracle Secure Backup, Oracle now offers the capability to insure that all Recovery Manager (RMAN) backups are created and maintained in a secure fashion, all without the need for a potentially expensive and cumbersome media management layer (MML). This article – the second in t

(Michael Armstrong-Smith) The following is an interesting conundrum that I have come across recently and is something that you might be interested in knowing about. It’s concerned with what happens when you combine sub-totals and additional rows between group sorted items.

(Bob Watkins) You may be running Oracle 10g Release 2, but the applications you’re supporting may have been written much earlier. Tables developed in versions of Oracle prior to 8i often used the LONG datatype to store large amounts of text.

(Padraig O’Sullivan) If you install a RAC environment on Solaris 10 and set kernel parameters using resource control projects (which is the recommended method in Solaris 10), then you will likely encounter issues when trying to start the cluster database or an individual instance using the srvctl ut

(Byte64) Lately i am working a lot with regular expressions. At first the syntax of regular expressions is rather tough to remember, but after a while a whole world of possibilities opens up to the developer.

(Steven Chan) The wait is over, at least for Linux platforms: Oracle Application Server 10g 10.1.2.2 has been certified with the E-Business Suite Release 11i.

(Brian Peasland) Currently we have a table in an Oracle database. The size of this table is huge (around 30 to 35 GB). Also, there are a few indexes on this table. This table grows every month by around 2-3GB of data. (R)

(René Nyffenegger) With PL/SQL, it’s possible to create functions that return a nested table type of an object type. If the return value of such a function is given as the argument to the table() operator, it behaves like an ordinary table. I have already written about this in On emulating tables wi

(Greg Rahn) In my previous post, Bind Variables, I discussed why using bind variables is one of the most important fundamentals in engineering scalable database applications. I briefly touch on the point that cursor management is also very important. In this post I will go into why this is important