I’ve noticed this issue for a while – including earlier versions of
Toad – and thought I’d send out an e-mail to see if this is a feature
enhancement request or if I’m just missing a setting within the
Toad/Oracle IDE. I’m currently on 10.1.1.8 of the Toad for Oracle
Here’s the issue, when I type a sql statement this way:
FROM scott.emp t
The “t.” piece, will eventually display a pop-up list of the columns
within the scott emp table. I love that! Very useful, especially
with wide tables.
Now if I have a public synonym defined for scott.emp and I’m not
logged into the Scott schema and I enter this:
FROM emp t
the pop-up list of columns is not displayed after I enter the “t.”.
Why is that? Is it a bug/feature request or a switch I need to set?
An unrelated comment. I’ve been working with getting Harvest to work
with Toad. The Toad version 10 SCC interface to Harvest is much
improved. Thank you. It’s not perfect but I’m now under the
impression that most of these issues are within Harvest.