Applications

• Find Differences in 2 similar tables

  • See how a table has changed over the week
  • QA for data entry effort (before and after)
  • Verify expected changes due to code mods

• Compare the column names from MS-SQL and Oracle schemas

  • Or compare length of text columns

• Analyze whether duplicate keys are duplicate rows (heavy hand on the “submit” button?)

• See the results of modifying a query

  • Inner join vs outer join
  • Null predicate

Copyright © 1997-2024, Maryland Cold Fusion User Group. All rights reserved.