(Arup Nanda) John, the lead DBA at Acme Bank, is involved in a very important initiative regarding security and privacy. Jane, the chief information security officer of the company, has outlined Acme’s security strategy, and John has identified his team’s responsibilities.

(Charles Babcock) Jack Hughes, IS director for The Park Associates, operator of a 27-unit nursing home chain, says he’s not worried whether Oracle will support his PeopleSoft applications.

(Matthew Hart and Scott Jesse) An analysis of backup and recovery issues that get opened with Oracle Support Services revealed an interesting point: in situations where backups existed for recovery, a full restore of the entire database was initiated 40 percent of the time. In other words, when a h

This article explains how to resolve the error of executing an SQL statement with an inappropriate clause.

A join is a query that combines rows from two or more tables, views, or materialized views ("snapshots"). Oracle performs a join whenever multiple tables appear in the query’s FROM clause. The query’s select list can select any columns from any of these tables. If any two of these tables have a colu

(Renee Boucher Ferguson) Although the ink on the deal between Oracle Corp. and PeopleSoft Inc. is barely dry, third-party software developers that make their living selling add-on enterprise resource planning applications are bracing for a seismic shift in their business.

(Neaman) Run this script from your sqlplus session to find trace files. (script)

(Dr. Paul Dorsey) The Unified Modeling Language (UML) is a standard environment for object-oriented design and development. The most commonly recognized parts of the UML Modeling environment are class diagrams, which somewhat resemble ERDs. Class diagrams were originally designed to support object-o

(Yvonne L. Lee) At the Oracle Open World conference in December, Oracle announced Oracle 10g Release 2, a set of updates that will enable its products to build applications that integrate with other applications.

(Jeanette Burriesci and Doug Henschen) An IBM spokesperson responded thus to Oracle’s BI announcements at December’s Oracle OpenWorld: “It’s the same old story. Oracle is trying to recast itself as a player in markets where it has no market share and no credibility.” It’s a bit of a cheap shot,