In the Query Builder there's a User and Expert tabs for a Where clause, but in the User tab, you can select an equal (=) operator click a button to view data as the constant. However, in the grid it's not possible to multi-select rows to convert the equals to an IN operator. The only way to get the IN operator is to go to Expert, but then the nice grid of the rows are not there to be selected as it has to be manually typed in.
Is there a way to multi-select rows in the Simple users menu in Toad?
In Toad for Oracle 11.5, the Query Builder will have new features to allow multi-select of rows in an IN operator for a Where clause.
Toad for Oracle 11.5 is scheduled to be released on April 19th, 2012.
