(Richard Rendell) How do I set up a virtual private database in Oracle? Within a single database, the virtual private database (VPD) enables data access control by user through dynamically rewriting the users SQL statements to include and additional WHERE clause predicate. A security policy func

Basically, when you would like a PLSQL (or java or c) routine to be the «source» of data — instead of a table — you would use a pipelined function. PIPELINED functions will operate like a table.

(Scott Stephens) When coding a SQL statement with tables in master-detail relationships, it’s common to have to decide whether to write the query using the WHERE EXISTS (. . .) clause or the WHERE value IN (. . .) clause. You may resist using WHERE EXISTS because it has the awkward syntax of returni

(James Koopmann) It used to be that a DBA would sit in front of the terminal screen and continually hit the ENTER key to watch activity in the V$SESSION_WAIT view to try and get a glimpse of the bottleneck and wait activity for connected sessions. This in itself was a very tedious task and honestly

(Wez Furlong) PHP is largely a volunteer driven project; although there are a handful of regular “core” contributors, none of us are paid full time to sit down and develop PHP. Couple this with the fact that we’re spread out across the globe and you’ll see how it can be difficult to coordinate long-

DBCA is a utility that allows you to configure, manage, and create a database. It’s usually run during an initial database installation when you select the Create A Database option. You can either create a database based on database templates that ship with the software, or you can load a template f

(Darl Kuhn) Many enterprises have conflicting requirements for transaction processing and business reporting. For example, decision reporting cannot be allowed to degrade the performance of online transaction processing. Additionally, mission-critical systems are required to be highly available, wit

(Jim Czuprynski) Oracle 8.1.6 offered a new format for tablespace storage management – locally-managed tablespaces – that offers significant improvements in tablespace performance and free space management. Oracle 9i Release 2 improved upon segment storage in locally-managed tablespaces with the Aut

(Scott Stephens) Oracle developers often avoid objects because they don’t seem to fit cleanly into PL/SQL or SQL domains. There are many operations on objects that you can’t do through pure PL/SQL (e.g., dealing with reference pointers), and there are operations that you can’t do in pure SQL (e.g.,

(Robert Lemos and Matt Hines) Database software maker Oracle promised to quickly make patches available for more than 30 flaws found recently by a British security researcher. While details of the flaws have not been made public, researcher David Litchfield offered some general information about