(Bob Watkins) In computer security work, the principle of Least Privilege states that users should have the minimum privileges needed to do their jobs. Oracle has made a small change in Database 10g Release 2 (10gR2) to be more consistent with this principle: It has changed the meaning of the CONNEC

(Patrick Sinke) This is just a simple trick which is not well-known but makes life easier when using the good ol’ SQL*Plus commandprompt (and many people still do!).

(Steve Callan) Quest Software recently released version 9.0 of Toad for Oracle, its “industry-leading, proven database development and administration tool that increases user productivity and application code quality.” Management solutions offered by Quest include application, database, and Windows

(Matt Hines) Oracle is aiming to help companies improve their ability to manage and protect sensitive customer information with a new initiative that encourages businesses to isolate such data outside of individual IT applications.

(Jayaram Krishnaswamy) Queries are quantitative questions you pose to a database. Questions such as “how many employees make more than $20,000.00 a year?” or “which employee has worked for more than two years?” are typical examples. In some cases, to answer questions like the ones above, you may go

(Chetan) This paper will walk you through the steps of installing Oracle Database 10g release 2 (Oracle version 10.2.0) in a Linux environment. About 90% of the material presented here applies to other platforms as well. Everything you read in this paper is hands on, roll-up-your-sleeves-and-get-bus

(Jeffrey Hunter) One of the most efficient ways to become familiar with Oracle Real Application Clusters (RAC) 10g technology is to have access to an actual Oracle RAC 10g cluster. There’s no better way to understand its benefits—including fault tolerance, security, load balancing, and scalability—t

(Lucas Jellema) While writing useless queries for solving exotic challenges, I realized that the use of dummy tables or unions of selects against DUAL for producing a few data-rows is a awkard solution to a problem that has a much more elegant one. Using a database type and the TABLE operator we hav

Oracle’s database technology is four times less secure that the much-derided SQL Server from Microsoft, a new study has concluded.

(Jim Czuprynski) Oracle 10gR2 enhances and expands data security with new row-level security features that ensure a user can only view, add, or modify data based on specific virtual private database (VPD) rulesets. This article – the second in this series – discusses how these new features improve u