Online Documentation for SQL Manager for Oracle

Using Navigation bar and Toolbar


The Navigation bar and Toolbar provide quick access to tools implemented in View Editor.

 

View Editor - Using Navigation bar

 

Object

iconDB select a database

iconObjects_View select a view for editing

 

General

iconCompile compile the view (if it is being created/modified)

iconPrint set printing options to print metadata of the view

iconTools_QB edit the view query using Design Query

iconRefresh refresh the content of the active tab

iconRestoreDefaultSize restore the default size and position of the editor window

 

View

iconTools_DependencyTree view the dependency tree for the view

 

Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with the view:

 

Keys

iconObjects_AddPK add a new primary/unique key

iconObjects_EditPK edit selected primary/unique key

iconObjects_DropPK drop selected primary/unique key

 

Foreign Keys

iconObjects_AddFK add a new foreign key

iconObjects_EditFK edit selected foreign key

iconObjects_DropFK drop selected foreign key(s)

 

Triggers

iconObjects_AddTrigger add a new trigger

iconObjects_EditTrigger edit selected trigger

iconObjects_DropTrigger drop selected trigger(s)

 

Data Management

iconCommit commit transaction

iconRollback rollback transaction

iconTools_ExportData export data from the view using Export Data Wizard

iconTools_ExportAsSQLScript export data from the view as Execute Script using Export as SQL Script Wizard

iconTools_ImportData import data into the base table

iconAddRestorePoint add restore point

 

Description

iconSaveToFile save object description to file

iconCopyToClipboard copy description to clipboard

 

DDL

iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data

 

NB: You can enable\disable Toolbars and Navigation bars at Environment Options.