Tag: Oracle

Community

Auditing Tells All

(Arup Nanda) Suppose user Joe updates a row of the table as shown below, assuming he has update privileges on that table. update SCOTT.EMP set salary = 12000 where empno = 123456; How do you track this activity in the database? In Oracle9i Database and below, auditing captures only the “who”

Community

Oracle Ousts Its Own Execs

(Renee Boucher Ferguson) In the midst of swapping out executives at recently acquired PeopleSoft Inc., Oracle Corp. is also making some internal adjustments. The company quietly replaced two top executives last week, including Ron Wohl, executive vice president of application development, according

Community

The Luxury of Architecture

(George Demarest) On a windy night in July of 1545, the British war ship Mary Rose and her crew slipped beneath the waves off the southern coast of England in full view of her patron, King Henry VIII. Severe conditions, an outmoded design, and good old-fashioned panic had sealed her fate.

Community

Oracle Stored Procedures

(Mooh the Cow) So what’s this business with Oracle allowing programmers to put programs in databases? That’s right. They’re called Oracle stored procedures, and they’re quite useful. The author walks you through writing, creating, debugging, and deleting a procedure.