Oracle SQL Developer - 缺少网格的查询结果窗口
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/3618526/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle SQL Developer - Query results window with grid missing
提问by Jody
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.
我刚刚从 MS sql 服务器切换到 Oracle。我使用的查询工具是 Oracle SQL Developer。我遇到的问题是我无法获得查询结果窗口。查询结果窗口是结果的网格视图。当我打开一个新的“sql工作表”时,它似乎是任意显示的。但不总是。然后一旦我运行一个查询,它就会在我下次运行时消失。
Can anyone point me to a consistent way to leave this results grid active? Thanks so much.
任何人都可以指出我保持此结果网格处于活动状态的一致方法吗?非常感谢。
回答by Jody
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. F9or Ctrl+ Enterget me to the query results grid view. Hopefully this helps someone else in the future.
好,朋友们。弄清楚了。我正在按 F5(如在 MSSQL 查询分析器中)来运行查询。这就是这个客户端中的“运行脚本”。 F9或Ctrl+Enter让我进入查询结果网格视图。希望这有助于将来的其他人。
回答by ramavtar
I also faced same issue. in Script output only line apearing was
我也面临同样的问题。在脚本输出中只有行 apeering 是
PL/SQL procedure successfully completed.
PL/SQL 过程成功完成。
set SERVEROUTPUT ON
helped in this case.
set SERVEROUTPUT ON
在这种情况下有帮助。