SQL 开发人员优化连接视图 [英] SQL developer refine connections view

问题描述

我在谷歌等上搜索了这个，但找不到解决方案:

I searched about this on google and so, but could not find a solution:

我正在使用多个模式和数据库连接为 Oracle SQL 开发人员工作.假设我有连接 1，其中包含架构 1 和表 1.然后我有连接 2，其中包含架构 2 和表 2，依此类推...

I am working on Oracle SQL developer using multiple schemas and database connections. Lets say i have connection 1 which has schema 1 and table 1. Then i have connection 2, which has schema 2 and table 2, and so on...

我必须时不时地在表 1 和表 2 中查找信息，......等等......这意味着在我的小笔记本电脑屏幕上进行大量导航、滚动等.如果有一种方法可以隐藏不需要的模式对象，那将使生活变得更加轻松.例如，我只需要处理表格，不需要视图、过程、索引、触发器等可见(在左侧菜单 - > 在连接下) - 这将减少滚动很多，希望我会能够在单个视图中查看连接 1 下的表和连接 2 下的表(无需滚动).有没有办法从视图中删除这些不需要的对象?

Every now and then i have to lookup information in table 1 then table2, .... and so on... which means a lot of navigation, scrolling etc. on my small laptop screen. it would make the life much easier if there was a way to hide the unwanted schema objects. For example, i only need to work with tables, don't need views, procedures, Indexes, Triggers etc. to be visible (on the left hand menu-> under connections) - that will reduce the scrolling a lot and hopefully i would be able to see tables under connection 1 and tables under connection 2 in single view(without scrolling). Is there a way to remove these unwanted objects from the view?

对不起，如果这听起来像一个愚蠢的问题，但我不精通 SQL 开发人员，因此非常感谢任何帮助.谢谢！

Sorry if this sounds like a dumb question, but i am not SQL-developer-savvy, so any help is greatly appreciated. thanks!

推荐答案

打开首选项对话框

进入数据库页面

查找、导航过滤

启用右下角的功能，然后取消选中您不想浏览的内容

enable the feature on the right bottom, then uncheck what you don't want to browse

这篇关于SQL 开发人员优化连接视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！