Chat now with support
Chat with Support

SQL Navigator for Oracle 8.1 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Difference Viewer

The Difference Viewer displays the compared objects in a split window. Differences between the objects are highlighted, and the toolbars and menus give you access to controls for customizing the view and creating reports.

 

The Difference Viewer Toolbar

Icon Tool Tip Description
Reload and recompare files Reload the external SQL/text files. Recompare.
Open files Open an external SQL/text file.
Save Save to an external SQL/text file.
Switch sides Switch left and right sides.
Find Previous Difference Go to the previous difference.
Find Next Difference Go to the next difference.
Show All Show all lines of the compared objects.
Just Show Differences Show only lines with differences.
Just show major differences Show only lines with major differences (as defined by File Comparison Rules).
Just show matching lines Show only matching lines.
Find Find a text string.
Find again Find the next occurrence of the text string.
Go to line number Go to a specific line number.
Copy To Right Replace the selected line (right) with the selected line (left).
Copy To Left Replace the selected line (left) with the selected line (right).
Delete left text Delete the selected line (left).
Delete right text Delete the selected line (right).
Undo Undo the change made to the selected line.
Produce file differences report Generate a report of differences.
Comparison summary Compare similarities and differences in a summary.
Show whitespace Show/Hide space characters as tilde (~) characters.
Show line numbers Show/Hide line numbers.

Show thumbnail view

Show/Hide thumbnail view.

The thumbnail view (to the left of the viewing window) is a visual summary of differences. Colored lines show the relative position of line mismatches. A white rectangle represents the part of the text currently visible in the Difference Viewer window. You can click on the thumbnail view to position the viewer at that point.

Use to quickly change locations within the viewing window.

Show line details Show full details of the current line below the viewing window (so you don’t have to scroll to see the entire line)
File comparison rules Open File Comparison Rules.
Options Open Viewer Options.

View Differences Dialog

Select objects or scripts to compare in the Difference Viewer.

Difference Viewer | Options

| Options

Appearance | Color Scheme

  1. Select a color scheme for each of:
    • Matching Text
    • Similar Text
    • Different Text

  2. Define how missing text should be displayed.

    Select Color and click Select Color to choose the color block to show to represent missing text.

    Alternatively, select Blank.

  3. Click Font to customize the font, font style, font size and script.
  4. Select Horizontal Lines Between Mismatches if desired.

TIP: All changes to the appearance can be previewed in the sample viewer display in the Viewer Options window.

Appearance | Find Next Difference

Customize finding the next difference.

Difference Viewer | Rules

| Rules

General

Option Description

Tab Stops

Set the width of Tab Stops displayed in the Difference Viewer.

Synchronization Settings

The Synchronization Settings control the workings of the comparison engine that reports differences and similarities between the two files. You can set the synchronization parameters low to allow more efficient searches for small differences, or higher for handling larger files or files with large differences. Unless you are experienced in manipulating comparison synchronization algorithms, you will probably find that the default settings work well enough for most situations.

Option Description
Initial Match Requirement The minimum number of lines that need to match in order for text synchronization to occur.
Skew Tolerance The number of lines the Difference Viewer will search forward or backward when searching for matches. Smaller numbers improve performance.
Suppress Recursion Suppress Recursion refers to the method used to scan for matches. Recursion improves the ability to match up larger as well as smaller sections of text, but it can take longer.

Ignore Minor Differences
Selected Ignore minor differences so you can focus only on significant differences.
Not Selected Highlight minor differences in the Difference Viewer window. Minor Differences are as defined in the Define Minor tab.

 

Define Minor

Option Description
Case

Select the items you want highlighted as minor differences. Items not selected will be ignored.

Ensure General | Ignore Minor Differences is not selected.

Leading Whitespace
Trailing Whitespace
Embedded Whitespace
/* Text within Slash-Asterisk */
(* Text within Parenthesis-Asterisk *)
{ Text within Curly Braces }
Text Beginning With
Fortran Comments
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating