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开发者_如何学C 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.
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.
I also faced same issue. in Script output only line apearing was
PL/SQL procedure successfully completed.
set SERVEROUTPUT ON
helped in this case.
精彩评论