SHIFT-F9
This will run only the SQL that your cursor is on. You do not need to highlight the line or the entire SQL statement; simply place your cursor anywhere inside the SQL statement and click SHIFT-F9.
CTRL-F9
This will verify (parse) the statement without executing it.
CTRL-E
This will execute an explain plan on the current statement.
F8
This will bring up your previous SQL statement. If you use SHIFT-F9 and are disciplined about keeping all iterations of executed statements in the screen…