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

Maraboc · Accepted Answer · 2017-10-23 10:51:32Z

269

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, 2017 at 10:51

Maraboc

11.1k3 gold badges43 silver badges51 bronze badges

answered Sep 1, 2010 at 14:03

Jody

8,3614 gold badges29 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

FrustratedWithFormsDesigner Over a year ago

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.

gjvdkamp Over a year ago

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!

user565869 Over a year ago

Related: stackoverflow.com/questions/479408/…

Rubio Over a year ago

Having previously worked with SSMS F5 is hard-wired in my mind, so I reassigned F5 in SQL Developer to run the query.

Roberto Over a year ago

Thanks, this helped me too. Tools > Preferences > Shortcut Keys for anyone that wants to remap "Run Statement" to F5.

|

hotzst · Accepted Answer · 2016-02-11 13:49:51Z

2

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, 2016 at 13:49

hotzst

7,53410 gold badges44 silver badges74 bronze badges

answered Feb 10, 2016 at 17:04

ramavtar

411 bronze badge

1 Comment

Rubio Over a year ago

There's also the Dbms Output window (View > Dbms Output). Click the plus button to add DBMS_OUTPUT to your connection.

Collectives™ on Stack Overflow

Oracle SQL Developer - Query results window with grid missing

2 Answers 2

6 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related