(Jeff Hunter) This article provides the basic steps and instructions for installing Oracle10gAS on the Microsoft Windows operating environment. Please keep in mind that this article should not be considered a substitution for completing reading and understanding the official installation guide and r

(Lilian Hobbs, Susan Hillson, Shilpa Lawande and Pete Smith) In Chapter 7, we described materialized views, which can be used to precompute and store results of frequently used queries. A major benefit of doing this is that you can use query rewrite to transparently rewrite queries to use these mate

(Ravi Nookala) It is difficult to display all the details of a given partitioned table without repetition of column values. This PL/SQL block is useful because it saves you from searching for the tablenames where the datails are available and how to join the tables. It is embedded with unique coding

(Christopher Jones) Oracle 10g Instant Client (free download available) is the easiest way for PHP to connect to a remote Oracle database, requiring installation of only three libraries. The Instant Client libraries used by PHP access Oracle’s current API, called OCI8. (This C interface takes it

(Kailash Awati and Arati Apte) Applications often require row-level access control to data – i.e. users should be able to see only rows that they are authorized to. As a concrete example: consider an order processing system where a number of clerks enter orders into a single table. In such a sit

(James Koopmann) Explore how to enable and disable Oracle tracing with DBMS_MONITOR package in 10g.

Oracle is moving beyond its focus on selling more databases and applications into an era of listening to customers who say they’ve got too much data and too many databases to manage.

(Puneet Sangal) Migration to an Oracle database from an existing system can be daunting, especially when the existing database exhibits few or no similarities to the Oracle database structure. This Technical Note will compare and contrast two techniques for Microsoft Access-to-Oracle migration: the

(Jonathan Boutelle and Rashmi Sinha) In the construction business, any remodeling job is a lot easier when the infrastructure has the right elements in place to support the desired changes—the wiring and plumbing meet current building codes and are situated in the proper location for a kitchen remod

Regular expressions specify patterns to search for in string data using standardized syntax conventions. A regular expression can specify complex patterns of character sequences. For example, the following regular expression: a(b|c)d searches for the pattern: ‘a’, followed by either ‘b’ or ‘c’