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.
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
To display ROWIDs
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.
select rowidtochar(rowid), emp.* from employee emp
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
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.