Use this dialog box to find data or columns in a grid. If the records are cached then the search is fast. If Toad has to query ahead in the recordset, then you have to wait for the additional rows to be fetched from the database.
You can use this method to find data in one column, or in many, or items that match two or more criteria.
To find data or columns
- Right-click the grid and select Find Data (CTRL+F).
-
Select the column to search or find.
- To find a column, select Find Column and click OK. The data grid advances to the first occurrence of the search criteria.
-
To find data, select Find Data and complete the search criteria. When you click OK, the data grid advances to the first occurrence of the search criteria.
Note: To find the next occurrence of the search criteria, press F3.
- To filter by data value, select Filter Data and then enter the search value. Note: Closing the dialog will undo the filter, but the grid will remain on whatever row you filtered to.
-
Note: To find the next occurrence of the search criteria, press F3.
Incremental Searching
To find data incrementally
- Click in the column you want to search.
- Type the first few characters of the item you want to find.
- Press F3 to continue stepping through the grid.
Filters reduce the amount of data displayed and let you display only what you want to see. They work by modifying the query used to fetch the data. If you frequently search for the same criteria, you can save the filter for reuse.
To filter data
-
Right-click the data grid and select Filter Data.
- To change the grouping clause, click AND to select a different option.
-
Click press the button to add a new condition.
- To change the column, click the listed column and select a new one. The first column in the grid is selected by default.
- To change the condition, click equals and select the appropriate condition (LIKE, EQUAL TO, LESS THAN, and so on).
- Click <empty> and add your criteria.
- To add additional conditions or groupings, click Filter and then select Add Condition or Add Group.
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
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
