Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

SQL Navigator for Oracle 7.6 - User Guide

Table of Contents

Better code, faster. Who should use SQL Navigator? Enter A New Authorization Key Check for Updates

Working With SQL Navigator

Oracle Sessions Finding Objects Working With Objects Web Development Java Source Code Analysis And Tuning Team Coding and Version Control

File Menu Edit Menu Search Menu View Menu Session Menu Object Menu Tools Menu Team Coding Menu Help Menu

Task Bar Toolbars Component List Connection Category Color Main Menu Keyboard Shortcuts Customize The Screen Layout

Oracle Logon Dialog Oracle TNS Configuration Dialog Advanced Service Options Dialog Address List Options Dialog DBA Dictionary Views Troubleshooting Connections to Oracle Command Line Parameters

Code Editor SQL Code Editor PL/SQL Edit, Compile And Execute

SQL*Plus command support Auto Code Completion Scan Defines/Substitutions New Stored Object Dialog SQL Statement CRUD Matrix Dialog

SQL Query Results

SQL Query Results Data Grid SQL Query Log (The Spool Tab) Export Data Dialog Viewers: LOB, XML, Array

PL/SQL Execution Console

PL/SQL Stub DBMS_OUTPUT

Code Editor Keyboard Shortcuts Toolbox

PL/SQL Debugger Code Explorer Outline DB Explorer Describe History Dependencies Columns

Visual Object Editors

Cluster Editor Constraint Editor Database Link Editor Index Editor Nested Table Editor Profile Editor Redo Log Group Editor Role Editor Materialized View Editor Sequence Editor Synonym Editor Table Editor User Editor Varray Editor View Editor Java Editor Instance Property Editor

Team Coding and Version Control Systems

Objects Supported by Team Coding Administer Team Coding

Install Team Coding Team Coding Settings Team Projects

Setup Team Projects

Team Coding Roles

Configure Team Coding

Configure Concurrent Version Systems (CVS) Configure Git Configure IBM Rational ClearCase Configure Perforce (P4) Configure Serena PVCS Version Manager Configure Subversion Configure Team Foundation Server

Team Coding Status Team Coding Manager Provider logon

Using Git Using Perforce Using IBM Rational ClearCase

Check in and Check out Version Control Systems

Concurrent Version Systems (CVS) Requirements More about Git and SQL Navigator More about Rational ClearCase and SQL Navigator More about Perforce and SQL Navigator More about Team Foundation Server and SQL Navigator

Modules, Windows And Dialogs

Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis

Code Analysis Window Code Analysis Rule Sets Code Analysis Rules

Add to Catalog & Edit Dialogs

Model Code Dialog

Code Shortcuts And Templates Dialog

Test Case Properties

Database Source Code Search Dialog DB Navigator

Filter Properties Dialog

Describe Difference Viewer

View Differences Dialog Difference Viewer | Options Difference Viewer | Rules

Edit Data ER Diagram

Create 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

Jobs Tab Programs Tab Schedules Tab Windows Tab Window Groups Tab Job Classes Tab Job Log Tab Window Log Tab Job Scheduler (Requirements)

Locate In Tree Output Window PL/SQL Profiler

Profiler Filter/Preferences Dialog New Group / Group Properties Dialog PL/SQL Profiler Requirements

Profile Manager Project Manager

Project Filter Dialog

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

View Joins Dialog Global WHERE Conditions Window Global HAVING Coditions Window

Model Area Tabs

Criteria Generated Query Query Results

SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code

View | Preferences

General | User Interface General | "Drop" and "Truncate" safety options General | Session General | Default Tables General | Explain Plan General | Code Assistant General | Printing General | Object Editors General | Task Bar

Extract DDL | General Extract DDL | Table/View Specific Extract DDL | Constraints Extract DDL | Materialized Views/Snapshots Extract DDL | Users

Project Manager Code Editor

Code Editor | General Code Editor | SQL Scripts

Lob Viewer Team Coding Keyboard Shortcuts

Technical support resources Copyright information Third-party contributions

General | Explain Plan

| Explain Plan

Explain Plan

Option

Description

Explain Plan Table Owner

User name of the owner of the default plan table.

Explain Plan Table

Name of the default plan table.

Table Access Full warning Threshold

The number of rows that must exist in a table before the icon in the execution plan is changed from green to red to draw your attention to the full table scan.

Abbreviate Join Text

Select to abbreviate the text that is displayed in the execution plan for table joins.

The abbreviation feature reduces the large amount of join text associated with a large query so that you can focus on the overall steps in the execution plan.

Explain Plan Color

The color of the individual items in the execution plan.

TIP: Click the ... button, then click the Color column in the row of an item to select a new color.

General | Code Assistant

| Code Assistant

Code Assistant

Option	Description
Auto Start with Editors and Explain Plan	Open Code Assistant automatically when an editor or the Explain Plan Tool is opened.
Standards Catalog Directory	The directory path for the Standards Catalog.
Shared Catalog Directory	The directory path for the Shared Catalog.

Displayed Pages

Option	Description
Syntax Catalog	Show the Syntax Catalog in the Code Assistant.
Web Catalog	Show the Web Catalog in the Code Assistant.
Code Catalog	Show the Code Catalog in the Code Assistant.
SQL Catalog	Show the SQL Catalog in the Code Assistant.

PL / Vision Catalog

Option	Description
PL / Vision Lite	Show the PL / Vision Lite Catalog in the Code Assistant
PL / Vision Professional	Show the PL / Vision Professional Catalog in the Code Assistant.

General | Printing

| Printing | Editors options are applicable to the Code Editor.

Printing

Option

Description

Measurement Units

The measurement unit for margin width and other print settings.

Header and footer

Enable/Disable headers and footers on printed output.

Note: Header and footer properties are specified separately (see below).

Font

The font to be used for printing SQL Navigator output.

Margins

Option	Description
Left Margin	The width or height of the page margins using the Measurement Unit specified above.
Right Margin
Top Margin
Bottom Margin

Header

Option

Description

Font

The page header properties.

Be sure to enable Header and Footer (above) if you want headers and footers to be printed.

Alignment

Footer

Option

Description

Font

The page footer properties.

Be sure to enable Header and Footer (above) if you want headers and footers to be printed.

Page Number

Date

Editor

Option	Description
Syntax highlighting	Applicable to output printed from an editing window; for example, the Code Editor.
Show line numbers

DB Navigator

Applicable to output printed from DB Navigator.

Option	Description
Header	Type the text you want to appear as header text in the printed output from DB Navigator.
Orientation	If you select a printer orientation other than Default, your setting will override any setting made in the Print Setup dialog when you print.
Print Selection	Print the selected item or the entire DB Navigator Tree.

General | Object Editors

| Object Editors

Object Editors

Option

Description

Auto Recompile Dependents

Selected	Automatically recompile dependent objects when an object is altered.
Not Selected	Force a manual recompile of dependent objects based on your preference. This is the default.

Auto Recompile Invalid Only

Selected	Automatically recompiles only the dependent objects that have a status of invalid.
Not Selected	Force all dependent objects to recompile automatically when using the debugger feature.

Apply changes

This option specifies the conditions necessary for the Apply Changes toolbar button to be available. Select to have the button available

only when you have made changes to valid objects, or
when you have made changes to any objects (valid or invalid), or
available at all times.

Save on clone

Select to automatically save a cloned object without prompting.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center