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.
You can hide columns from the data grid after running a query.
To select columns to display
in the upper left corner of a data grid.
Clear the checkbox by the column name.
Tip: To sort the column list alphabetically, right-click the column list and select Sort Alphabetically.
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.
If the query does not contain an ORDER BY command, you can sort the grid manually.
To sort by column
