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.


View Editor - Using Navigation bar



iconDB select a database

iconObjects_View select a view for editing



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

iconPrint set printing options to print metadata of the view

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



iconObjects_AddPK add a new primary/unique key

iconObjects_EditPK edit selected primary/unique key

iconObjects_DropPK drop selected primary/unique key


Foreign Keys

iconObjects_AddFK add a new foreign key

iconObjects_EditFK edit selected foreign key

iconObjects_DropFK drop selected foreign key(s)



iconObjects_AddTrigger add a new trigger

iconObjects_EditTrigger edit selected trigger

iconObjects_DropTrigger drop selected trigger(s)


Data Management

iconCommit commit transaction

iconRollback rollback transaction

iconTools_ExportData export data from the view using Export Data Wizard

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

iconTools_ImportData import data into the base table

iconAddRestorePoint add restore point



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.