(René Nyffenegger) With Oracle’s regular expressions, it’s relatively easy to split a string into it’s words. Easy, that is, compared with a solution that doesn’t use regexp_substr. It still requires some amount of setup as the following steps show.

(Vincent Chan) Ever experience the frustration of managing several copies of the tnsnames file on servers or desktops, or coordinating the distribution of the file to all your corporate users only to realize later that an incorrect file was distributed? These hassles can easily be avoided with centr

(Bob Watkins) Oracle’s export and import utilities were re-engineered in Release 10g. Buried among the more flashy features, such as the ability to disconnect and reconnect to a running export or import job, are a number of smaller changes that help the DBA reorganize tablespaces. Here are three of

(Arif Mohamed) Most Siebel users in the UK have seen no difference in the level of service they have received since the CRM supplier was acquired by Oracle a year ago. However, 17% have reported a decline in service levels.

(Lewis R Cunningham) Have you ever needed to lookup something for Oracle 8.1.7 and couldn’t find the documentation? Ever want to compare features between two Oracle versions? Go to Tahiti!

(Aradhana Puri) The Oracle Certification program offers three distinct certification levels for Oracle Database 10g— Associate, Professional, and Master —shown in Figure 1. The three levels are organized to suit the needs of entry-level, professional, and senior-level IT professionals, respectively.

(Patrick Sinke) We all are at least a bit aware of the awkward behaviour of NULL in Oracle. But it still is difficult every time we encounter it in a function or where-clause.

(Renee Boucher Ferguson) After Oracle’s move in 2000 from client/server to Web-based applications with its E-Business Suite 11i—a notoriously buggy technology shift—the company isn’t taking any chances with its next big development undertaking.

(Mark Brunelli) Oracle says the newest version of its free Application Express software makes it easier for developers to build applications for Database 10g using nothing but a Web browser. (R)

(schola) The following code snippet shows how to retrieve an Oracle BLOB column data and save it as a JPEG file. Before using this code, you must create an OracleCommand object with a valid Oracle connection. To see how to create an OracleCommand and OracleConnection, see ADO.NET section of this sit