(Jagadish Chatarji) This is the third article in a series focusing on associative arrays. In this article, we shall examine recommended methodologies for working with associative arrays even more professionally than in the previous article.

(Richard Stroupe) Previously in Oracle 9i RAC, customers who purchased the RAC option also had to depend on third-party venders such as Sun, Veritas and HP for cluster management support. Using multiple vendors for any high availability (HA) solution is very problematic and could introduce many obst

(Werner Puschitz) This article discusses Red Hat Enterprise Linux optimizations for x86 (32 bit) and x86-64 (64 bit) platforms running Oracle 9i R2 (32bit/64bit) database, and Oracle 10g R1 and R2 databases (32bit/64bit). This guide covers Red Hat Enterprise Linux Advanced Server 2.1, 3, and 4.

(Liujian (LJ) Qian) This white paper introduces briefly the main features of the up coming Oracle Spatial database 10g and Oracle Application Server MapViewer 10g. Through a case study we also show that these off-the-shelf products can serve as effective building blocks for large-scale spatiotempora

Using the Oracle Clusterware 10g Release 2, together with Oracle Application Server 10g Release 2 offers customers a high availability solution fully developed and supported by Oracle. With Oracle Clusterware 10g Release 2, Oracle Clusterware can be implemented independently of Real Application Clus

(Sandra Henry-Stocker) I often find myself needing to verify whether an Oracle database is working. Sometimes a process running on one server extracts data from a database on another server and, if the process fails, testing the connection to the database is a good starting point from which to deter

(Raj Mattamal) As a product manager for Oracle Application Express (formerly Oracle HTML DB), I often want to gather feedback on workshops or training sessions I deliver. Using Oracle Application Express to quickly create surveys has proven to be so useful that I figured I’d write about it. Even tho

(Kirby)This sample simply presents a message box indicating the Record Count to demonstrate a DSN-Less Connection. The sample included in the project documented in my Oracle Tutorial Web Site is more detailed and extensive.

(Jim Czuprynski) One of the last projects I worked on as a software developer before I became an Oracle DBA was to implement a complex upgrade to several stored procedures within my client’s DB2 database so that a new set of accounting rules could be applied to their commodities management applicati

(Catherine Devlin) PL/SQL is ideal for programming tasks within Oracle Database. Most Oracle professionals, however, aren’t confined to working strictly within the database itself. You’ve probably encountered many tasks for which PL/SQL has proven clumsy or even unusable—such as manipulating files o