Oracle SQL Developer - Query results window with grid missing

77
votes

I've just made the switch from MS sql server to Oracle. The query tool I am using is Oracle SQL Developer. The problem I am having is that I cannot get the query results window to stick around. The query results window being the Grid view for the results. It seems to show up arbitrarily when I open a new "sql worksheet". But not always. Then once I run a query, it disappears the next time I run one.

Can anyone point me to a consistent way to leave this results grid active? Thanks so much.

2
oracleoracleclientoracle-sqldeveloper
What version are you using? There are other tools out there, such as JOra (an Eclipse plugin), Squirrel SQL, and Allround Automation SQL Developer (commercial product - decent but has its own quirks). – FrustratedWithFormsDesigner
What version of SQL Developer are you using? – Ian Carpenter
v2.1.1. I'm being told by the powers that be to stick with this tool unless absolutely necessary. – Jody

2 Answers

248
votes

ok guys. figured it out. I was hitting F5 (as in MSSQL query analyzer) to run the query. That is "run script" in this client. F9 or Ctrl + Enter get me to the query results grid view. Hopefully this helps someone else in the future.

1
votes

I also faced same issue. in Script output only line apearing was

PL/SQL procedure successfully completed.

set SERVEROUTPUT ON helped in this case.