If the query does not contain an ORDER BY command, you can sort the grid manually.
To sort by column
- Click a grid column header.
- Select the appropriate option, and click Apply.
If the query does not contain an ORDER BY command, you can sort the grid manually.
To sort by column
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
Select the column to search or find.
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.
Note: To find the next occurrence of the search criteria, press F3.
To find data incrementally
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.
Click press the button to add a new condition.
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.
© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center