I have been using Toad for a very long time. Somewhere around version 10 Toad for Oracle changed the way it evaluated variables for table owner.
The syntax of course is owner.table name. In my unix environment native sql resolves a variable with the actual owner name.
For instance say I initialize a variable $SCHEMA to the table owner JOE. I can then write sql against the his tables with the basic Oracle syntax
However in Toad for Oracle it requires me to either value the variable to “JOE.” (name followed by a period) or even worse write the sql to have double periods
following the variable (select * from &&SCHEMA…JOES_TABLE).
This requires me to define a second variable for schema name if is part of the data returned. I also have to explain to each new junior team members that our unix and windows sql behave differently.
It’s not a major issue but still don’t understand why a 3rd Party tool would add such a requirement that is outside of Oracle’s syntax, especially when earlier versions already had it correct.
Prior releases did not have an override to this, but I would like to suggest that in future releases that either syntax be acceptable or an override be provided where you could just pass
an owner name to a variable and write the sql accordingly and Toad would resolve correctly. &&SCHEMA.JOES_TABLE
Just a thought!