Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

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

Check for Updates

Quick Overview > Check for Updates

Click Help | Check for Updates to check for the latest version of SQL Navigator available.

Is there a newer version to download from the web site?

Working With SQL Navigator

Oracle Sessions

Working With SQL Navigator > Oracle Sessions

Icon

Menu

Description

Session Menu | New Session

Connect to an Oracle database instance / Open a new Oracle session. Manage your database connections.

Open the Oracle Logon Dialog.

TIP: SQL Navigator saves your connection profiles in the Project Manager window for easy access.

Session Menu| Select

Switch between open Oracle Sessions.

TIP:

You can set up multiple sessions with one or many database instances.
Each session-related window (code editor, object editor, and so on) remembers and automatically opens in the appropriate database session.

Send to Session

Inside the Code Editor, while editing SQL code, you can send the current Code Editor tab or a selected piece of code to another session. Highlight the code and click Send to New Session. For more information, see Code Editor SQL.

SQL Navigator executes long-running tasks in separate threads in the background. The Task Manager is a display of all active and complete tasks for the current session.

TIP: Manage sessions in the Session Browser.

Finding Objects

Working With SQL Navigator > Finding Objects

SQL Navigator gives you several convenient point-and-click options for quick access to database objects.

Icon

Tool

Description

Explore the entire database structure as a tree with expandable nodes.

TIP: Highlight a DB Navigator node and press F11 to find objects in that node.

Find objects Dialog

Find objects by means of a search argument.

TIP: To show a dynamic list of all objects in a schema - Select the schema node in DB Navigator before you click Search | Find Objects.

Database Source Code Search

Search stored programs, triggers and views for a character string in the source code.

TIP: You can use this utility to perform a quick "where-used" impact analysis.

Show the location of the current database object (for example, the one you are editing) in the DB Navigator hierarchy. Expand all intermediate nodes in the DB Navigator tree and display the object’s detail view.

Find Recycle Bin Objects Dialog

Locate objects dropped in the recycle bin.

Requires Oracle 10g or 11g.

Project Manager

The Project Manager provides instant access to your frequently used database objects and connections. Projects are holding areas where you can store shortcuts to things that you frequently need to work with instead of searching for them in various lists and directories.

TIP: To find an object in DB Navigator from Project Manager: Right click on the object in Project Manager and select Locate in DB Navigator. This opens the DB Navigator window, expands tree nodes as necessary, and displays the details of the selected object.

TIP:

Use the Find Objects Dialog or DB Navigator for multiple-selection of objects.
Your view of the Oracle Data Dictionary determines what objects you can see. For more information, see DBA Dictionary Views.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center