FYI, I found (and submitted an support ticket) for this soon after upgrading to 10.6.
for those of you that use the ‘edit’ command in an editor tab, beware that only one line is getting executed when you hit ctrl-enter, click the execute snippet button, or highlight the statement and hit the execute button. I.E.:
This is not a bug but a feature. The EDIT toad command is spelled the same as
the EDIT SQLPlus statement. Also Toad (rightfully so) has succeeded in
supporting just about all SQLPlus idiotsyncrasies.
This is fixed in the upcoming 10.6.1, for Shift+F9 (Ctrl+enter) only. If you are
using F9, the where clause on the 2nd line is ignored as it should be.