Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents 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

Data Grid Basics

Throughout Toad, information is presented in a grid format. Within grids, you can customize grid views, filter resultsets, print the grid contents, and other standard operations. If the data set is editable, Toad enables that to be done within the grid.


About Data Grids

In most data grids you can:

Edit data:

  • Post/Revert Edited Data
  • Insert and Delete Rows
  • Edit Data in Popup Editor
  • Use an External Editor
  • Access the Calculator

Customize the data grid display:

  • Perform Calculations on Grid Cells
  • Anchor Column in Data Grid
  • View a Single Record
  • Preview Selected Column
  • Hide Columns
  • Sort and Group Data

Filter results:

  • Filter Data
  • Use Excel-Style Filtering

Export data:

  • Export Dataset
  • Export Data to Flat File

View special data types:

  • Date Editor
  • View BFILE data
  • View CURSORs
  • View Nested Table Data
  • View Object Data
  • View VARRAY Data


Anchor Column in Data Grid

You can anchor a column on the left side of the data grid (also referred to as locking, fixing, or freezing the column). This can make it easier to track information you must scroll through a large amount of content.

Note: Row numbers automatically display as fixed columns. With the exception of row numbers, fixed columns remain editable.

To anchor a column

Right-click a column and select Fix Column.

To remove the column anchor

Drag the column to the right of the bold fixed column divider bar.


Hide Columns

You can hide columns from the data grid after running a query.

To select columns to display

  1. Click in the upper left corner of a data grid.
  2. Clear the checkbox by the column name.

    Tip: To sort the column list alphabetically, right-click the column list and select Sort Alphabetically.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating