EMS logo


SQL Manager for Oracle

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Documentation en ligne

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:



iconDB select a database

iconObjects_MaterializedView select a materialized view for editing



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



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



iconSaveToFile save object description to file

iconCopyToClipboard copy description to clipboard



iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data


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