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.