I like a combo of both solutions with some additional preference setup:
1) I downloaded plug-in "Execute Current Statement" (new name for "Compile Current"?)
2) Set the following preferences:
- Window Types:
- Program Window -> Ignore unrecognized PL/SQL
- AutoSelect statement
- User Interface -> Key Configuration
- SQL Window: Execute current statement: Ctl+F8
- Plug-Ins / [ExecuteCurrent] ... / Execute current statement: Alt+F8
- Plug-Ins / [ExecuteCurrent] ... / Execute current tab: Shift+F8
I now have the following behavior:
F8: run statement under cursor in SQL Win, compile all in Pgm Win
Ctl+F8: run all in SQL Win, n/a in Pgm Win
Alt+F8: run statement under cursor in SQL Win, n/a in Pgm Win
Shift+F8: n/a in SQL Win, compile only current tab in Pgm Win
Patrick, since "Execute current statement" seems to only apply in the SQL Win and "Execute current tab" only applies in the Pgm Win, could you combine both into 1 command that takes the appropriate action for the window your in?
I tried setting both to the same hotkey and that didn't work (darn!)