(Murali Vallath) If you’ve been waiting to take advantage of the extensive list of new features and functionality in Oracle Database 10g and Oracle Real Application Clusters (RAC) 10g, there’s no longer any need for delay. In September 2005, Oracle Database 10g Release 2 and Oracle RAC 10g Release 2

(Tarry Singh) I have gotten many e-mails from professionals and novices alike, and can fully understand the sentiment of taking all the pains of getting ready to install the Oracle installer (Clusterware is more sensitive to this), and then it just won’t budge beyond an error. In one sense, it is go

(Mark A. Williams) A ref cursor is a reference to a result set that resides in server memory. When a ref cursor is opened, no data is initially returned to the client. Instead, the address where the data resides is passed to the client and the client can choose how and when to process the data repre

(James F. Koopmann) Oracle has once again given us what we asked for, almost. A simple way to generate the DDL for objects defined in the database.

(Andrei Cioroianu) Asynchronous JavaScript and XML (Ajax) is a recent term for a group of mature APIs, technologies, and standards that can be used with all major browsers. Besides HTML/XHTML, CSS, JavaScript, XML, and DOM, the so-called Ajax applications use an API named XMLHttpRequest, which lets

(Kevin Loney and Bob Bryla) Export and Import provide you with an indirect method for the upgrade. You can create an Oracle 10g database alongside your existing database and use Export and Import to move data from the old database to the new database. When the movement of the data is complete, you w

(Joshua Wright and Carlos Cid) In this paper the authors examine the mechanism used in Oracle databases for protecting users’ passwords. We review the algorithm used for generating password hashes, and show that the current mechanism presents a number of weaknesses, making it straightforward for an

This tutorial explains the ways and steps of creating and managing database accounts, Creating Users through Sql Plus, Creating User through iSQL*PLUS, Creating Users through EM, Manager Users, Managing Users through sqlplus and Managing Users through EM.

(Steve Muench) As you’ve seen in my previous columns, an Oracle Application Development Framework (ADF) entity object represents a business domain entity such as an order, a part, a customer, or a service request. By creating a set of associated Oracle ADF entity objects that represents the full bus

If you notice poor performance in your Oracle database Row Chaining and Migration may be one of several reasons, but we can prevent some of them by properly designing and/or diagnosing the database.