(Jagadish Chatarji) This article introduces you to the REF CURSOR in Oracle PL/SQL. I’ve included numerous examples to help you understand how to work with REF CURSOR.

(Alex Gorbachev) Oracle CRS 10.2.0.3 patchset brings long awaited removal of previously required dependencies of databases and ASM instances on a VIP. Actually, 10.2.0.2 patchset lifted the requirement for dependency between ASM instance and VIP but not for database instances. In 10.2.0.2 this depen

(James F. Koopmann) The amount of time a user or application has slept through the USER_LOCK.SLEEP or DBMS_LOCK.SLEEP procedures.

(Roger Schrag) Prior to Oracle 10g, one of the only supported ways to move an Oracle database across platforms was to export the data from the existing database and import it into a new database on the new server. This works pretty well if your database is small, but can require an unreasonable amou

(Lewis Cunningham) A FAQ that I get, well, frequently, is about overloading procedures. I think most people get how to overload but not when or why. Today I am going to explain a classic example of where overloading makes your life easier. More importantly, it makes the life of the code maintainer b

(Lucas Jellema) A quite common concept in many programming langiages, though perhaps strongest in Java, is the String Tokenizer. This is a utility class or function that takes a String as input, and optionally one or more delimiters, and breaks up the string in individual elements, returning those a

(René Nyffenegger) In my last blog entry, I have written a little Excel macro. This macro opens a connection to an Oracle database, issues a select statement and then iterates over each record within the result set. For each record, it also iterates over each attribute within this record.

(Peter Galli) Sun Microsystems will spend more than $200 million consolidating all of its internal business applications onto Oracle 11i and, while the move is expected to generate minimal savings in fiscal year 2008, it should yield major savings in fiscal year 2009 and beyond.

(Michael Milonov) The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet, and DataAdapter. DataReader is only able to read data and can’t work as data so

(Lucas Jellema) One of the more important concepts in the domain of Service-Oriented Architecture (SOA) is that of Event-Driven Architecture (EDA). Similar to the event mechanism in, for example, JavaScript or 4GL environments where triggers—pieces of executable program code—can be hooked into event