When you process an index-by table in PL/SQL, there are times when you cannot be sure of the indices that exist on the table, so you can’t use the most obvious form of the FOR loop to loop through values. (R)

After reading this how-to document you should be able to: –Execute an Anonymous PL/SQL block using ODP.NET –Save Image data from a file to database –Write Image data to a file from database

(Brad Cowdrey) This article will take an in-depth look at the advanced aggregation features including formatting using the GROUPING function and composite grouping through examples including syntax and behavior. In addition, this article will build on the information and examples from the previo

(Tom Szekely, Gil Candia and Danny Pham) This paper discusses the use of Oracle’s Redefinition Package to perform online reorganizations in Oracle 9i and 10G databases. The paper describes the redefinition process, the commands used to perform the redefinition online, and certain limitations an

(Dr. Robert J. Pefferly, Jr., Yuri Schimke, and Tanel Unt) The Second Law of Thermodynamics, also known as "entropy," dictates that the chaos of a system increases with time and decreases if and only if outside energy (work) is applied to order the system. In the world of programming, this law often

After reading this how-to document you should be able to: –Select and update Lobs(Large OBjects) from an Oracle database –Use the Resultset Locking feature of ODP.NET

(Duncan Mills) So after my earlier frustrations at tracking down the integration library I push on. –The first step is to switch JDeveloper to use Struts 1.2.4, a simple drop in replacement as I’ve mentioned before. The JSF RI is already plugged into my IDE, so it’s just the Integration stuff to

(Martha Centeno) This Redpaper introduces the concept of flexible database clusters as a method for addressing the challenges inherent in the management of mission-critical database applications. The components selected for building a flexible database cluster include IBM BladeCenter and xSeries ser

With Visual Basic 5.0 and higher Enterprise edition, you have the ability to connect to an Oracle database through a DSN-Less connection, execute a stored procedure using parameters, and get return values from that stored procedure. The example in this article illustrates all of this functionality.

(Steve Callan) Part One of Oracle Response Files covered the basics of using a response file and provided an example of how to install Developer Suite on a Windows PC. In Part Two, we will go into more detail about the components of response files. This part will also discuss some related topics as