Chat now with support
Chat mit Support

Toad for Oracle 2025 R3 - 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

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.

 

Use the Calculator

You can access a calculator within Toad data grids. To use the calculator, the table must be editable. Understand Editable Resultsets

To access the calculator

  1. Click in a numeric cell. A drop-down arrow displays.
  2. Click the arrow to display the calculator.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen