Database News You Can UseDecember 2001
A monthly newsletter for Oracle users
from Database Specialists, a consulting firm
specializing in Oracle technology
In this issue:Handy New Script for Comparing Data in Two Oracle Schemas
Looking for a valuable script for comparing data in two Oracle schemas? You’ll find one on the Database Specialists website! This script reads all the rows in a specified list of tables in one Oracle schema and compares the data row for row against tables with the same names in another schema. You’ll get a report with summary counts of differing rows, and SQL queries you can run to view all of the data discrepancies. You can specify columns to exclude from the comparison, such as creation timestamps or IDs generated by a sequence. This script can be quite helpful when data in multiple schemas is supposed to be the same and you want to make sure that it is. This includes situations such as comparing seed data in separate databases, validating regression test data in a QA environment, or testing data load scripts. Download this script and many others at http://dbspecialists.wpengine.com/scripts.html.
Oracle OpenWorld ended with the “Oracles of Oracle” panel discussion on December 7. Each panel member was asked to share a piece of advice for those working with Oracle technology. Here is some of the advice they shared.
The panel members were: Ian Abramson – DataVisions; Bill Burke – I2; Ari Kaplan – Expand Beyond; Roger Schrag – Database Specialists; Matt Swann – Amazon.com; Joe Trezzo – TUSC.
If you’ve ever wondered about the similarities and differences between Java and PL/SQL, here’s your chance to get some insight. At last month’s Northern California Oracle Users Group quarterly conference, Joe Greenwald of ODK Incorporated led a technical session that shed some light on how Java and PL/SQL differ in such areas as development tools, data types, and reusability.
The Northern California Oracle Applications Users Group will be holding their next regional Training Day at the PG&E Learning Center in San Ramon, California on January 23rd, 2002. Starting with breakfast at 7:30 a.m. and running through 4:00 p.m., this will be a jam-packed day of opportunities to learn and exchange information with your peers about Oracle Applications. There will be six concurrent learning tracks to choose from.
This event costs only $40 if you register in advance.
As this year draws quickly to a close, we’d like to take a moment to thank all of you for the continued success of The Specialist. We are happy to share some of the exciting news in the Oracle community as well as provide resources to help you as Oracle users. Best wishes for the upcoming New Year!