This White Paper discusses the issues and options involved in the creation of small referentially correct versions of large Oracle databases.

by John Bechtle – Do you want to track statistics on the number of times your Oracle database is logged on to, or do you get queries about when is the last time some particular account accessed the database? This trigger will update the database keeping statistics on who logs on to the database and

By Jonathan Gennick – The new 2nd edition of our Oracle SQL*Plus Pocket Reference includes many new features for Oracle9i. It also adds sections on basic SQL: INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject,

by Joe Lax – SQL Server and Oracle each have very different methods for maintaining data constancy when accessed by concurrent users. Oracle maintains a snapshot of the data, which prevents queries from hanging without stooping to "dirty reads." Find out how it works.

Oracle has released an updated version of the TopLink Java development tool it recently acquired from WebGain, along with a road map pledging continued TopLink support for competitors’ databases and application servers.

by Karen Kolbe – I picked this script off the internet 4-5 years ago. The previous version had created 2 views for the final select, but I have incorporated all the selects into a single statement.

SQLTools is a light-weight, robust tool for ORACLE database development that includes a text editor, SQL console and a couple of SQL utilities. Small enough to fit on a floppy disk and able to be used on a dial-up connection, SQLTools is a handy, portable, free program that works as fast as SQLPlus.

By Regimon Kallinkal – There is often a need for comparing the current row with the next row for different reasons in data warehousing strategies. Instead of cursoring through an entire table to compare values between current and next records, this technique is faster. Cursors are generally slower f

By Eric B. Parizo – Oracle Corp. has made a big splash in the Web services pond as of late, leading an effort to encourage the World Wide Web Consortium (W3C) to develop a common standard for Web services choreography. SearchWebServices.com spoke with Jeff Mischkinsky, director of Web services stand

Oracle9i includes support for the SQL92 join syntax. Find out why it’s important to have the choice to make a condition a join condition in this article by Jonathan Gennick, author of Oracle SQL*Plus Pocket Reference, 2nd Edition.