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?
Quick Overview
Working With SQL Navigator
Oracle Sessions
Finding Objects
Working With Objects
Web Development
Java Source Code
Analysis And Tuning
Team Coding and Version Control
Navigation
Main Menu
Oracle Logon
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
Code Editor SQL
Code Editor PL/SQL
Edit, Compile And Execute
Visual Object Editors
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
Code Editor Keyboard Shortcuts
Toolbox
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
Configure Team Coding
Modules, Windows And Dialogs
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
Check in and Check out
Version Control Systems
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
View | Preferences
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
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
General
About Us
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
Extract DDL | General
Extract DDL | Table/View Specific
Extract DDL | Constraints
Extract DDL | Materialized Views/Snapshots
Extract DDL | Users
Project Manager
Code Editor
Lob Viewer
Team Coding
Keyboard Shortcuts
Check for Updates
Quick Overview > Check for Updates
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.
| ||
 |
Session Menu| Select |
Switch between open Oracle Sessions.
| ||
 |
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.
| |||
 |
Find objects by means of a search argument.
| |||
 |
Search stored programs, triggers and views for a character string in the source code.
| |||
 |
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. | |||
 |
Locate objects dropped in the recycle bin. Requires Oracle 10g or 11g. | |||
 |
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:
|