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
General | Explain Plan
| Explain PlanExplain 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.
|
General | Code Assistant
| Code AssistantCode 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.
| ||
| 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. |