Regular expressions represent a powerful tool for describing and manipulating text data. These are supported by a wide variety of programming and scripting languages, text editors, and now by Oracle Database 10g SQL and PL/SQL. It is a method for simple and complex patterns for searching and mani

(Amar Kumar Padhi) Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for a very specific purpose.

(Olivier Le Diouris) JAX-B is the specification that implements the Java Api for XML Data Binding (JSR 31). It basically allows java programmers to deal with the content of an XML Document, without having to deal with an XML Parser’s Api.

(Vijayanandraj Amaladoss) This code snippet demonstrates how to use Oracle VARRAY through JDBC. The code does three things: –It creates VARRAYs of different lengths. –It contains a table to store data of above array type. –Stores the objects in an array, and inserts them into database

(Ryan Ordway) By far, the most common RDBMS platforms for Linux-based systems are MySQL and PostgreSQL, due to their inclusion in most major Linux distributions. Quite a few shops still run legacy databases, however, using commercial database servers such as Sybase or Oracle. Even Linux Journal gave

(Jim Czuprynski) Oracle 10g’s new DBMS_SCHEDULER package offers significant improvements over DBMS_JOB for scheduling jobs and tasks. This article – the second in a series – provides practical examples of using the Oracle Scheduler’s new functionalities, including a discussion of transitioning from

(Emmett Dulaney) Underlying every conditional statement is a test to see what is true and what is not. Knowing how this works can make the difference between writing mediocre scripts and ones you’ll be proud of.

(Barbara Darrow and Steven Burke) Oracle President Chuck Phillips spoke with CRN Industry about Oracle’s midmarket application offensive and the launch of its E-Business Suite Special Edition North America, which will be sold exclusively through select partners.

(Paul Gallagher) If you’re a DBA or a developer using Oracle-compliant tools, you almost certainly on occasion apply tracing to active database sessions, usually in the hunt for rogue SQL or some other coding misdemeanour.

(Kimberly Floss)In a busy production environment with many active users, tracing a SQL session is time-consuming and complicated, because processing SQL statements in any multitier system that uses a connection pool can span multiple processes, or even different instances. With Oracle Database 1