Toad for Oracle 15.0 - Getting Started Guide

Insert/Delete Rows

The dataset must be editable for you to make any changes. Understand Editable Resultsets

To insert a blank row

Click on the data grid toolbar.

To copy an existing row

Right-click the cell you want to copy and select Duplicate Row. If you have a sequence set, then the sequence number advances when you finish editing.

To delete a row

Click on the data grid toolbar.

Post/Revert Edited Data

The dataset must be editable for you to make any changes. Understand Editable Resultsets

To post data

1. Make changes to an editable resultset in the data grid.
2. Click in the grid navigator.

To revert data

Click in the grid navigator.

Edit Data in Popup Editor

You can view and edit data in a Popup Editor. This feature is helpful when there is too much data to view in the data grid.

Note: The dataset must be editable for you to make any changes. Understand Editable Resultsets

To edit data in the Popup Editor

Right-click a cell in the data grid and select Popup Editor.

Perform Calculations on Grid Cells

You can perform basic calculations on data grid cells, such as finding the sum or average of the selected cells.

Note: This feature is not available if Row Select is enabled. To disable Row Select, right-click the grid and clear the Row Select option.

To perform calculations on grid cells

1. Select adjacent cells in the grid.

   Note: Calculations on non-adjacent cells is not supported.

2. Click in the grid toolbar (CTRL+N). The calculations display in a new row below the grid.

   Tip: You can also right-click the grid and select Calculate Selected Cells.

3. To include additional types of calculations (such as the average or count), click the arrow by and select the appropriate options.