Online Documentation for SQL Manager for Oracle

Using Navigation bar and Toolbar

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


Procedure Editor - Using Navigation bar


The Navigation bar of Procedure Editor allows you to:



iconDB select a database

iconObjects_Procedure select a procedure for editing



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

iconExecute execute the procedure

iconDebug debug the procedure

iconPrint set printing options to print metadata of the procedure

iconTools_DependencyTree view the dependency tree for the procedure

iconRefresh refresh the content of the active tab

iconRestoreDefaultSize restore the default size and position of the editor window

iconCompileWithDebugInfo compile with debug info


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


Data Management

iconCommit commit transaction

iconRollback rollback transaction



iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data


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