Replace all for multiple occurrences of bind variable

Toad for Oracle - Beta
1

Howdy,

When I'm running a SQL with multiple occurrences of a bind variable with F9:

SELECT &1+&1+&1+&1+&1+&1+&1+&1 FROM DUAL;

...Toad dutifully pops up the Variables window, but shows a separate variable entry for each occurrence. Shouldn't this just be a single replacement? Subsequent runs of the same SQL automagically substitute the last value of the first occurrence for each.

Or am I using this wrong? Which is not only possible, but probable. :jack_o_lantern:

Thanks!
Rich

2

Replace '&' with '&&'.

https://asktom.oracle.com/pls/apex/asktom.search?tag=regarding-and

3

Ha! See? I knew it was me! I probably had that knowledge 20 years ago, but lost it somewhere along the way from lack of use.

Thanks for finding it again for me, Doug! :smiley:

Rich