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.
A data grid is fully editable providing that the query itself returns a resultset that can be updated. Query statements must return the ROWID to be editable. For example:
select * from employee
select employee.*, rowid from employee