Oracle SQL Developer - Query results window with grid missing

Question

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.

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, Sep 01 '10 at 13:36
v2.1.1. I'm being told by the powers that be to stick with this tool unless absolutely necessary. — Jody, Sep 01 '10 at 13:49

score 264 · Accepted Answer · edited Oct 23 '17 at 10:51

264

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.

edited Oct 23 '17 at 10:51

Maraboc

10,550
3
37
48

answered Sep 01 '10 at 14:03

Jody

8,021
4
26
29

1

Yeah, now that sounds familiar (I think I've done that once or twice, but so long ago...). And in some tools it's F8. I think it's possible to remap that if you want to be consistent with other tools. – FrustratedWithFormsDesigner Sep 01 '10 at 16:11
3

Thanks! Also digging into Oracle, this SQL developer makes this a lot easier than Toad. Man that thing has so many buttons it makes my head hurt! – gjvdkamp Oct 15 '10 at 10:35
1

Related: http://stackoverflow.com/questions/479408/execute-statement-or-run-script – Jun 06 '14 at 14:55
1

Yeah, Microsoft SQL Server Management Studio uses F5. It's a common thing to try to use F5 on Oracle. Did the same thing. But that was my case, I was using MS SQL Management studio. – Malavos Jan 23 '18 at 19:00
6

Having previously worked with SSMS F5 is hard-wired in my mind, so I reassigned F5 in SQL Developer to run the query. – Rubio Jul 17 '18 at 10:43
6

Thanks, this helped me too. Tools > Preferences > Shortcut Keys for anyone that wants to remap "Run Statement" to F5. – Roberto Feb 06 '19 at 22:11

score 1 · Answer 2 · edited Feb 11 '16 at 13:49

1

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

PL/SQL procedure successfully completed.

set SERVEROUTPUT ON helped in this case.

edited Feb 11 '16 at 13:49

hotzst

7,238
9
41
64

answered Feb 10 '16 at 17:04

ramavtar

31
1

There's also the Dbms Output window (View > Dbms Output). Click the plus button to add DBMS_OUTPUT to your connection. – Rubio Jul 17 '18 at 10:40

Oracle SQL Developer - Query results window with grid missing

2 Answers2

Linked