Chat now with support
Chat with Support

Toad for Oracle 13.1.1 - Getting Started Guide

Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Insert/Delete Rows

Work with Data > 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

Work with Data > 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

Work with Data > 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

Work with Data > 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.

 

Related Documents