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

Preview Selected Column

You can display or hide a full row below each data row that shows the value of the selected column.

To preview current column

Right-click the column in the Data grid and select Preview Column.

 

Include Row Numbers

Toad can display row numbers and ROWIDs in the Editor data grid.

The total number of rows returned in the resultset will display in the status bar at the bottom of the window only after you have scrolled to the end of the resultset. This is because the resultset is fetched only as required, to improve overall performance. When the last row is fetched, Toad will display the total count.

To display row numbers

Select View | Toad Options | Data Grids | Visualand then select Show row numbers (applies to data grid on Browser also).

To return the Oracle pseudo-column ROWNUM in the SQL Results grid

To display ROWIDs

Select View | Toad Options | Data Grids | Dataand then select Show ROWID in editable grids.

You can achieve the same result by adding the following to the query:

select rownum, emp.* from employee emp

Remember that rownum is an Oracle pseudo-column, not stored with the table definition or data, but derived when queried.

To return the ROWID in the query, specify the column and the datatype:

select rowidtochar(rowid), emp.* from employee emp

 

Copy Column Names to the Clipboard

You can copy the names of selected columns in the data grid to the clipboard. The names are copied in the order they are listed in the grid, for use in WHERE clauses or other tasks where you need a list of column names.

To copy column names

  1. In the data grid, click (column selector) in the grid header, then select the columns that you want to copy.
  2. Select the sort order (alphabetical or grid order, the default).
  3. Right-click the selected column list, then select Copy checked columns to clipboard.

 

Work with Data

Throughout Toad, information is presented in a grid format. Within grids, you can customize grid views, filter result sets, print the grid contents, and other standard operations. Grids that provide query results have additional functionality. In most data grids you can edit data, perform calculations on grid cells, and sort and group data, among many other things.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating