Using Toad Base or Pro editions of Toad and connected to an Oracle database, running a query with below bind variables, will only prompt for the second variable value:
select column1
from tablename
where column1='1&1'
and column2='&2'
Running this query in SQLPlus will prompt for both variables.
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.
