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:
|
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:
|
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. |
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center