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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-10 02:45:54  来源:igfitidea点击:

Oracle SQL Developer - Query results window with grid missing

oracleoracleclientoracle-sqldeveloper

提问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 查询分析器中)来运行查询。这就是这个客户端中的“运行脚本”。 F9Ctrl+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 ONhelped in this case.

set SERVEROUTPUT ON在这种情况下有帮助。