When working with tables that contain hundreds of columns but few rows, it is better to look at the data transposed with each column name as a row and with each row as a column.
Basically, the equivalent of exporting the data to Excel, selecting it, and choosing paste, transpose.
The card view in Toad was an attempt at doing that, but it fails miserably because:
1. It repeats the column names on every "card" --
...more »
When working with tables that contain hundreds of columns but few rows, it is better to look at the data transposed with each column name as a row and with each row as a column.
Basically, the equivalent of exporting the data to Excel, selecting it, and choosing paste, transpose.
The card view in Toad was an attempt at doing that, but it fails miserably because:
1. It repeats the column names on every "card" -- wasting valuable screen real-estate.
2. It does not contain a vertical scroll bar, so if there are hundreds of columns, there's no practical way to get to them.
Desired: a new option on in the Results Window: Right-Click: Show: menu that reads: "Transposed View".
When selected, users would see data with the column names in the first column (frozen in place). Scrolling vertically displays the other columns, scrolling horizontally displays the other rows but keeps the column names visible.
« less
full details »
Social Web