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 Log Editor.


Materialized View Log Editor - Using Navigation bar


The Navigation bar of Materialized View Log Editor allows you to:



iconDB select a database

iconObjects_MaterializedViewLog select a materialized view log for editing



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

iconPrint set printing options to print metadata of the materialized view log

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


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 log:



iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data


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