Question: how to get multiple query result window in sql developer?
Answer: Run Statement, Shift+Enter, F9, or this button.
No grids, just script (SQL*Plus like) ouput is fine, thank you very much!
Scroll down, or hit Ctrl+End to force a full fetch and get all your rows back.
Run one or more commands plus SQL*Plus commands like SET and SPOOL.