Open Oracle Developer.Click “View” and then click “Dbms Output.”Click the green “+” sign in the window that opens and select the database connection from which you want output. Output will now appear for that database in a new tab.

How do I see the query output in SQL Developer?

1. Open Oracle Developer.
2. Click “View” and then click “Dbms Output.”
3. Click the green “+” sign in the window that opens and select the database connection from which you want output. Output will now appear for that database in a new tab.

How do I see multiple query results in SQL Developer?

1. Run Statement, Shift+Enter, F9, or this button.
2. No grids, just script (SQL*Plus like) ouput is fine, thank you very much!
3. Scroll down, or hit Ctrl+End to force a full fetch and get all your rows back.
4. Run one or more commands plus SQL*Plus commands like SET and SPOOL.