(Drew Robb) Databases usually have two things in common. They have grown far larger than envisioned by their creators and they are filled with unneeded data. Many companies, therefore, are seeking to pare them down to the essentials and archive little used content. But what should you archive, how s

Oracle Text is a tool that enables you to build text query applications and document classification applications. Oracle Text provides indexing, word and theme searching, and viewing capabilities for text.

This page is a great collection of tips and tricks for Oracle – from online links to the user manuals to query exeucution details to how to enable constraints with locking tables and much more. This is one article not to miss!

(Robert Clevenger) Are you ready to start using PHP to talk to an Oracle Database? Let’s walk through the steps required to install the Oracle Database, Apache HTTPD Server, and PHP as an Apache module on Linux. Check out the OTN Linux Center to see what versions of Linux are certified for use with

(Budi Kurniawan) The upcoming J2EE 1.4 includes the new Servlet 2.4 and JavaServer Pages (JSP) 2.0 technologies for Web application development in Java. This article offers a look at the new features in both specifications and provides sample code for each feature where appropriate. The article assu

The Java API for XML-based remote procedure calls (JAX-RPC) provides standard way of building portable and interoperable SOAP based Web Services. It simplifies the process of building Web services that incorporate XML-based RPC. In JAX-RPC, a remote procedure call is represented by an XML-based prot

A "normal" join finds values of two tables that are in a relation to each other. In most cases, this relation is equality (=), but it can also be all sorts of operations that either return true or false. The important thing is that a "normal" join only returns rows of both tables of which the compar

(Steve Callan) Last month’s “Connecting with Oracle” article dealt with properly configuring the tnsnames.ora file. Using a statistics-related analogy for a minute, you can have Type I and Type II errors with respect to your tnsnames.ora file. You can have a “good” tnsnames.ora file, but “reject” it

(Matt Bauer) Mobile applications and technologies have created an increased need for storing, mapping, and analyzing spatial data. Traditional database techniques have stored this spatial data in X and Y columns to form various geometries. This technique allows only limited indexing and querying, ma

(James Koopmann) If you want to get the most out of Oracle, you will have to learn how to size its internal memory structures. Let’s take a look at the Shared Pool, what it is composed of, and a new tool that Oracle has given us tune it. As an Oracle DBA, you quickly learn one the golden rule in