如何在 Oracle SQL Developer 中查看数据库的模式树列表?

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

How do I view a Tree list of Schemas for a database in Oracle SQL Developer?

oracle

提问by TampaRich

How do I view the schemas, that belong to a database in SQL Developer? I am trying to get a view similar to Toad. In that you have the database name at the parent level, all the schemas below it which are then expandable to view all the objects that belong to that particular schema.

如何在 SQL Developer 中查看属于数据库的架构?我正在尝试获得类似于 Toad 的视图。因为您在父级别拥有数据库名称,它下面的所有模式都可以展开以查看属于该特定模式的所有对象。

回答by dpbradley

Expand the "Other Users" node.

展开“其他用户”节点。

回答by Ashu

Two steps :

两个步骤:

  • Right click on the connection you have created
  • Choose option Schema Browser to get the view of all schema in the drop down list along with the tables.
  • 右键单击您创建的连接
  • 选择选项模式浏览器以获取下拉列表中所有模式以及表的视图。