Viewing the row differences - Data Compare for Oracle

The lower (Row Differences) pane displays a side-by-side listing of values for the tables and views you have compared. To display the Row Differences pane, click a table or view in the comparison results.

By default, all rows with differences are selected for deployment. Use the Include check boxes to include or exclude the rows.

In the example above, for the row where PURCHASEID = 1:

• PURCHASEID is the comparison key.
• QUANTITY is the same in both databases so the data is displayed in gray text
• The WIDGETPRICEID and INVOICENUMBER values are different so they are displayed with the darker shaded background

Shading on the column names also indicates differences. A column name with full shading indicates values that are different; a column name with partial shading indicates values that only exist in one of the data sources.

Invalid values

You cannot include a row for deployment if it contains a value that is outside of the range of its datatype. These values are displayed with the message: Value is invalid for datatype.

If there are any invalid values in the comparison results, a warning symbol () is displayed in the Row Differences pane:

Searching the data

Tip: You can search the values in the Row Differences pane using the Find box. To search for a value:

1. Right-click any value in the Row differences pane, and click Find:

   

2. Type your search text in the Find box, and then click or to find the next or previous matching value.

For a short example video, see: Using the Find box.

Pivoting the data

To rotate the data so that you can view the values for a record as a group, click Show, and select Pivot View; the values are displayed vertically:

This is useful when there are a large number of columns in a table. Note that you cannot change the sort order of the columns when you are viewing the data in the pivot view.

To scroll through the records, hold down Shift and rotate the mouse wheel.

To show the next or previous difference, use the arrow buttons or press the shortcut keys; the values that differ are shown with a green background.

Viewing the data

To view values with highlighted differences, double click a value in the Row Differences pane.

For more information, see Viewing the data.