(Steve Callan) Part 3 of this series examines some new functionality found in Oracle10g’s Enterprise Manager Console. In prior releases of Oracle (as shown in the first two parts of this series), patching and patch administration were manually performed by the DBA. In 10g, some of that workload

(Renee Boucher Ferguson) Oracle Corp. announced that it has certified its PeopleSoft Enterprise applications to run on Oracle Fusion Middleware 10g Release 2, a move that will provide more integration capabilities for Enterprise users—and streamline the upgrade path to Oracle’s next-generation appli

(MS Sridhar) Oftentimes, a query will return null values for some of the columns in a query. However, to display “null” as the value in the generated report isn’t a very effective way to display this information. Oracle provides an easy solution for this problem.

(George Demarest) For thousands of years, we have used measurements in all walks of life, even if our early practices were a bit more approximate than they are today. For a very long while, a foot of measurement was actually the length of your foot.

In Oracle, you can create an autonumber field by using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.

(Terry Sutton) In this paper we will present a method for retrieving data from an Oracle database that cannot be opened normally because one or more datafiles is inconsistent with the others. An example of a scenario where you would find yourself in this situation is as follows: A disk failed on

(Barry McKay) Many developers have been won over by the elegance and efficiency of PHP5’s implementation of object-orientation, and are equally drawn to the power and robustness of the world’s foremost database, Oracle. However, taking the next logical step—storing PHP objects in your database for W

(Michael Blaha) Referential integrity is a database constraint that ensures that references between data are indeed valid and intact. Referential integrity is a fundamental principle of database theory and arises from the notion that a database should not only store data, but should actively seek

(Jagadish Chaterjee) In this article, I shall introduce you to developing, deploying and testing a .NET based CLR stored procedure with Oracle database using Visual Studio.NET.

(James F. Koopmann) It has been my observation that a lot of us lack the basic skills required to model the simplest of database objects. This article will explore some of the common mistakes and fixes to the breaking of 1NF.