CODEWITHSUNDEEP
oracle-databaseoracleclientoracle-sqldeveloper
Jody
Jody

Reputation: 8291

Oracle SQL Developer - Query results window with grid missing

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.

Upvotes: 83

Views: 111195

Answers (2)

Jody
Jody

Reputation: 8291

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.

Upvotes: 266

ramavtar
ramavtar

Reputation: 41

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

PL/SQL procedure successfully completed.

set SERVEROUTPUT ON helped in this case.

Upvotes: 2

Related Questions