EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Using Navigation bar and Toolbar


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

 

Materialized View Editor - Using Navigation bar

 

The Navigation bar of Materialized View Editor allows you to:

 

Object

iconDB select a database

iconObjects_MaterializedView select a materialized view for editing

 

General

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

iconPrint set printing options to print metadata of the materialized view

iconTools_QB edit the materialized 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 materialized 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 materialized view:

 

Data Management

iconCommit commit transaction

iconRollback rollback transaction

iconTools_ExportData export data from the materialized view using Export Data Wizard

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

iconTools_ImportData import data

 

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.