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

About Data Grids

Data Grid Basics > 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

Data Grid Basics > 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

Data Grid Basics > 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.

 

Understand Time Values

Data Grid Basics > Understand Time Values

When displaying times with dates, Toad suppresses the time values if they are 12:00:00 AM (midnight). The time portion of the date fraction is zero, so Toad adds no value to the display of the date.

Oracle stores dates as a big fraction number offset from January 1, 4712 B.C. It is then converted to a complete date and time.

Performing the query Select sysdate from dual will display the time, and similarly, queries of DATE datatype columns will display the time if it is not midnight.

The time drop-down in View | Toad Options | Data Grids does not affect this output of time.

 

Related Documents