Task Bar
The Task Bar lists all active SQL Navigator windows for the current project.
Use the Task Bar to select a SQL Navigator window to work on. That window is bought to the foreground, giving it focus.
|
|
TIP:
|
Toolbars
The following toolbars are available in the main window.
To show / hide a toolbar, right click over the Main Menu, any toolbar or task bar and select the toolbars to show.
| Toolbar | Description | ||
|---|---|---|---|
| Session Toolbar |
Duplicates some of the commands from the Session Menu.
| ||
| Edit Toolbar | Duplicates some of the commands from the File Menu and Edit Menu. | ||
| Functions Toolbar | Duplicates some of the commands from the View Menu, Tools Menu and Help Menu. | ||
| Object Toolbar | Duplicates some of the commands from the Object Menu and shows the current schema. | ||
| Team Coding | Duplicates some of the commands from the Team Coding Menu. |
|
|
TIP:
|
Component List
| Icon | Component Name | Description |
|---|---|---|
 |
Analyze Tool | View and collect statistics, validate structure and list chained rows for database structures such as tables, clusters and indexes. |
 |
Report on the attributes, methods and arguments of an object type. See also Describe. | |
 |
Benchmark Factory | Simulate user transactions before and during application deployments, enabling performance issues to be addressed before end users are affected. |
 |
View / Jump to / Delete bookmarks. See also Edit Menu. | |
 |
Browse Data |
View chained rows information. See Quick Browse. |
 |
Change Logon Password | Modify the logon password of the current session. |
 |
Cluster Editor | Join tables that are closely related for storing on the same area of the disk. This lets you interleave the rows of two or more tables together into a single area called a cluster. |
 |
Code Analysis | Analyze code against a set of rules for best practices. |
 |
Code Assistant | Drag and drop PL/SQL syntax, SQL functions, column names, and database object names into code. |
 |
Code Editor | Edit SQL and PL/SQL code. |
 |
Code Explorer |
Show a hierarchical view the code. See Code Editor | Toolbox | Code Explorer. |
 |
Code Road Map | Show the complex PL/SQL interdependencies within a database. |
 |
Code Search | See Database Source Code Search. |
 |
Code Templates | Insert ready-made code segments into any active editor window. |
 |
Code Test | Automate the process of testing PL/SQL programs. |
 |
Constraint Editor | Use the Constraint Editor to specify table constraints. |
 |
Database Link Editor | Use the Database Link Editor to view, create or define database links. |
| |
Database Source Code Search | Search stored programs, triggers and views for a character string in the source code. |
 |
DB Explorer |
Find and open database objects. See Code Editor | Toolbox | DB Explorer. |
| |
DB Navigator | Show the entire database structure as a tree with expandable nodes. |
 |
Report on the attributes, methods and arguments of an object type. See also Auto Describe Tool. | |
 |
Difference Viewer | Compare objects in a split view. |
 |
Edit Data | Edit data in a table object. |
 |
ER Diagram | Model a table and graphically see the dependencies and joins to other tables. |
 |
Explain Plan Tool | Analyze the execution of a single SQL statement. |
 |
Export Table | Export selected tables. |
 |
Extract DDL |
See also Object Menu. See also SQL Navigator Preferences: View | Preferences | Extract DDL | General. |
 |
Find and Replace | Find or replace text strings in the current text file. |
 |
Find objects Dialog | Find objects in any schema. |
 |
Find Recycle Bin Objects Dialog | Search for objects in the recycle bin. |
 |
Configure how the Formatter Tool formats code. Formatter tools are available from the Tools Menu. | |
 |
HTML Viewer | Show HTML in the integrated viewer. |
 |
Import HTML as PL/SQL | Convert a HTML file into a PL/SQL stored procedure. The stored procedure will in turn output the HTML code via the Oracle Web Toolkit. |
 |
Import Table | Import tables. |
 |
Index Editor | Use the Index Editor to view, create or alter indexes, and to set storage allocation. |
 |
Instance Property Editor | Use the Instance Property Editor to view or specify the startup parameters for the instance. |
 |
Java Editor | View and edit Java source. |
 |
Java Manager | Load and unload multiple Java source files, classes, resources and archives. |
 |
Job Scheduler | Access the Oracle Job Scheduler. |
 |
Locate In Tree | Jump to the selected object’s node in the DB Navigator tree. |
 |
Materialized View Editor | Use the Materialized (Snapshot) View Editor to view, create or define snapshots. |
 |
Nested Table Editor | Use the nested table editor when you require a large, efficient collection. |
 |
Open DB Object |
Select and open a database object similar to the standard Windows File | Open command. |
 |
Open Object at Cursor | See Edit Menu. |
 |
Oracle Logon Dialog | Manage your database connections, including to create a database connection. |
 |
Outline |
Show the syntax tree of the current source. See Code Editor | Toolbox | Outline. |
 |
Output Window | Show SQL Navigator messages and server output including Oracle errors. |
 |
PL/SQL Debugger |
Tools and features for debugging stored programs. See Code Editor | Toolbox | PL/SQL Debugger. |
 |
PL/SQL Profiler | Analyze the execution time and efficiency of your stored programs. |
 |
Profile Editor | Use the Profile Editor to view, create or alter profiles. |
 |
Profile Manager | Backup and Restore SQL Navigator profiles. |
 |
Product Authorization | See Enter A New Authorization Key. |
 |
Project Manager | The Project Manager window provides instant access to your frequently used database objects and connections. |
 |
Publish Java to PL/SQL | Create a PL/SQL package from a Java class stored in the database. |
| |
Quick Browse | View chained rows information. |
 |
Redo Log Group Editor | Use the Redo Log Editor to view, create, or alter Redo Logs. |
 |
Role Editor | Use the Role Editor to view or create roles. |
 |
Screen Layout |
Save up to ten layouts of dockable windows and recall them. See View Menu | Screen Layout |
 |
Search Knowledge Xpert | Drag and drop optimized routines directly into your program editor. |
 |
Sequence Editor | Use the Sequence Editor to view, create, or alter sequences. |
 |
Server Side Installation Wizard | Install server side objects. |
| |
Select DB Object Dialog | Select and open a database object similar to the standard Windows File | Open command. |
 |
Select Session | Switch between open Oracle Sessions. |
 |
Session Browser | Manage sessions in the Session Browser. |
 |
Source Preview | Preview the source code of text objects (stored programs, triggers and views), or a package’s individual entry points. |
 |
SQL History |
The History tool lists successfully executed SELECT, UPDATE, DELETE commands and PL/SQL blocks up to 1000 of the most recent ones in the current session. See Code Editor | Toolbox | History |
 |
SQL Modeler | SQL Modeler dialog provides a fast means for creating the framework of a Select, Insert, Update, or Delete statement. You can select Tables, Views, or Synonyms, join columns, select columns, and create the desired type of statement. |
 |
SQL Optimizer | The SQL Optimizer makes observations about a selected SQL statement and the underlying database environment, then recommends several options to improve performance. |
 |
Synonym Editor | Use the Synonym Editor to view or create synonyms. |
 |
Table Editor | Use the Table Editor to create, alter, or define tables. |
 |
Task Manager | 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. |
 |
User Editor | Use the User Editor to create, grant or revoke roles and privileges to users, including forcing a password to expire. |
 |
Varray Editor | Use the Varray Type Editor to create varying arrays. |
 |
View Editor | Use the View Editor to view, create, or alter views. |
| |
View Difference |
The Difference Viewer displays the compared objects in a split window. See Difference Viewer. |
 |
Visual Object Editors | SQL Navigator’s editing tools for database objects. |
 |
Wrap Code | The Wrap Code utility provides an easy way to access Oracle’s Wrap Code utility. |
Connection Category Color
Optionally assign a connection to a category color in the Oracle Logon Dialog.
Possible categories could be: development, test or production. You could create your own categories and assign colors as appropriate.
The color is displayed in the following places in SQL Navigator.
| Component Name | Description |
|---|---|
| Toolbars |
The connection entry in Session toolbar. |
|
|
The border of windows belonging to the connection. |
| Task Bar |
Task Bar icons of windows belonging to the connection. |
|
Tab icons of the Code Editor window. |
See also preference settings in View | Preferences | General | User Interface.