Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - 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

View Differences Dialog

Modules, Windows And Dialogs > Difference Viewer > 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

Edit Data

Modules, Windows And Dialogs > Edit Data

Use to edit data in a table object.

  1. Select the table object.
  2. Click Object | Edit Data.
  3. The Code Editor opens. The query is run with Updateable switched on. For more information, see SQL Query Results Data Grid.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating