Oracle SQL Developer 多表视图

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/1912129/
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:18:44  来源:igfitidea点击:

Oracle SQL Developer multiple table views

oracleoracle-sqldeveloper

提问by user232627

In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can add, delete, edit or just viewing records of table currently viewd

Oracle SQL Developer 中,可以在查看表时使用“数据”选项卡列出表中的数据。在那里可以添加、删除、编辑或仅查看当前查看的表的记录

the problem is that we often really need to view more than one table at once, then we need more than one tab opened, thing that i dont know how to do that, any sugestion. tq in advance

问题是我们经常真的需要一次查看多个表,然后我们需要打开多个选项卡,我不知道该怎么做,任何建议。提前tq

回答by a70m

SQL Developer can start a new tab every time you select a database object to view; but, you will have to close the tab manually.

每次选择要查看的数据库对象时,SQL Developer 都可以启动一个新选项卡;但是,您必须手动关闭该选项卡。

Set this in: Tools->Preferences->Database->ObjectViewer->Automatically Freeze Object Viewer Windows

将其设置在: 工具->首选项->数据库->ObjectViewer->Automatically Freeze Object Viewer Windows

回答by Jerome Dalbert

You can pin a tab by clicking the button below :

您可以通过单击下面的按钮固定选项卡:

Tab pin button

标签别针按钮

No need to configure anything, plus sometimes you don't want to have a tab automatically pinned.

无需配置任何东西,而且有时您不想自动固定选项卡。

回答by Nathan

Jeff Smith posted a nice write up on how to do this in SQL Developer.

Jeff Smith 发表了一篇关于如何在 SQL Developer 中执行此操作的好文章。

There are multiple ways to do it.

有多种方法可以做到。

  • Freeze content (ctrl-shift-P)
  • New Document Tab Group (will allow viewing tables simultaneously)
  • Change the preferences (If this is desired default behavior)
  • 冻结内容 (ctrl-shift-P)
  • 新文档选项卡组(将允许同时查看表格)
  • 更改首选项(如果这是所需的默认行为)

The post can be found here.

可以在此处找到该帖子。