A couple of items on the SQL Builder.
First, it would be lovely if pressing the tab key moved me one column to the right, staying within the same row. It’s a nuisance to have to take my hands off the keyboard, grab my mouse, point to the next cell, click the mouse button, and then start typing again. Major slow-down for me, and it has been the cause of some jeering at TOAD.
Second, I just created a view. The view combines a master table with several “satellite” one-to-many tables. These tables each look at (different) values in another table. Like so:
Table1 - Table2 - Table3a
- Table4 - Table3b
I added Table3 in twice, and aliased the table appropriately. Then I added in the columns from that table. Then I had to go and alias every single one of those columns, with a common prefix, to be able to ID which value went with which ancestor table. Major pain! It would be nice to be able to tell TOAD to add a common prefix to each column name in a given table in the SQL Builder.
Does this make sense?