Oracle SQL Developer - 缺少网格的查询结果窗口
我刚刚从 MS sql server 切换到 Oracle。我使用的查询工具是Oracle SQL Developer。我遇到的问题是我无法让查询结果窗口保留下来。查询结果窗口是结果的网格视图。当我打开一个新的“sql 工作表”时,它似乎任意显示。但并非总是如此。然后,一旦我运行查询,它就会在我下次运行查询时消失。
任何人都可以向我指出一种一致的方法来保持此结果网格处于活动状态吗?非常感谢。
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.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
我也面临同样的问题。在脚本输出中仅出现行
set SERVEROUTPUT ON
在这种情况下有所帮助。I also faced same issue. in Script output only line apearing was
set SERVEROUTPUT ON
helped in this case.好吧,伙计们。想通了。我按 F5(如在 MSSQL 查询分析器中)来运行查询。那是这个客户端中的“运行脚本”。 F9 或 Ctrl + Enter 让我进入查询结果网格视图。希望这对将来的其他人有帮助。
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.