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.

 

 

Object

select a database

select a view for editing

 

General

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

set printing options to print metadata of the view

edit the view query using Design Query

refresh the content of the active tab

restore the default size and position of the editor window

 

View

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

add a new primary/unique key

edit selected primary/unique key

drop selected primary/unique key

 

Foreign Keys

add a new foreign key

edit selected foreign key

drop selected foreign key(s)

 

Triggers

add a new trigger

edit selected trigger

drop selected trigger(s)

 

Data Management

commit transaction

rollback transaction

export data from the view using Export Data Wizard

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

import data into the base table

add restore point

 

Description

save object description to file

copy description to clipboard

 

DDL

save DDL to file

open DDL in Query Data

 

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