Online Documentation for SQL Manager for Oracle

Working with data


The Data tab displays the view data as a grid by default (see Data View for details). The context menu of this tab and the Navigation bar allow you to Export Data, Import Data, Export as SQL Script.

 

While working with view data, you are provided with a number of filtering and grouping facilities.

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

 

Data management tools are also available through the Navigation bar and toolbar of View Editor.

 

View Editor - Working with data

 

 

Note: You can add a restore point before changing data, to get an opportunity to flash back to the current data state.

Click iconAddRestorePoint Add restore point on the Navigation bar or toolbar to open the Add restore point dialog. For details see Adding restore point.