Online Documentation for SQL Manager for Oracle

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.