Select a Category

How to find difference in two datasets with SQL?

Problem

Need to make sure that two datasets are the same. One traditional way to compare them is importing their data into an Excel spreadsheet. Then one can use Excel function to find the difference.

Better Solution

Oracle provides MINUS operator, which can subtract second dataset from first dataset. For example:

Select * From […]

December 24th, 2014 | Category: Computer, Database, Oracle | Comments are closed

How to pull data from Oracle to Excel 2010?

Problem

How to display Oracle data to users without Oracle interface software? Most users have Excel 2010 installed. Excel 2010 can pull data from Oracle for display.

Steps to setup Excel to pull data from Oracle

Click on “Data” tab in Excel and select “From Other Sources” in “Get External Data” ribbon group. Select “Other/Advanced” […]

November 22nd, 2014 | Category: Computer, Database, Excel, Microsoft Office, Oracle | Comments are closed