EMS logo

Produkt Navigation

SQL Manager for Oracle

Unsere Partnerschaften

MySQL Gold Certified Partner
Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Online Bedienungsanleitung

Searching within the tree


SQL Manager for Oracle provides an ability to search for items within the DB Explorer tree. Searching for items may be useful if you have a lot of database objects, and it may be sometimes hard to find the one you need.

 

There are two search facilities implemented in SQL Manager for your convenience. You can search for objects within the DB Explorer tree in either of the following ways:

 

  • using the Find Object dialog

To call the Find Object dialog, right-click the Database alias, any database object group nodes or objects in the DB Explorer tree and select the Find Object... context menu item, or use the Ctrl+F shortcut.

 

DB Explorer - Find Object

 

 

Available search options are similar to those provided by the Find Text dialog. For detailed description of the search options refer to the Find Text dialog page.

 

Note: You can specify whether the search will be performed within the entire tree or within the currently selected node only: toggle search mode using the btnDBExplorer_SearchByCategory Search  by categories button on the Search Panel, or use the corresponding option available in the Tools | DB Explorer section of the Environment Options dialog.

  • using the Search Panel

Type in the first letters in the edit-box, and the corresponding object will be highlighted in the tree, as displayed in the picture below. The btnDBExplorer_SearchPrev btnDBExplorer_SearchNext buttons allow you to define the search direction. The btnDBExplorer_SearchByCategory button toggles searching by category.

 

DB Explorer - Search Panel

 

 

By default, the Search Panel is activated in the upper area of DB Explorer. To disable the panel, right-click within the panel and deselect the checkbox at the corresponding popup menu item.

 

DB Explorer - Search Panel - Customize

 

 

Hint: The Search Panel is dockable, i.e. you can drag it to any location within the DB Explorer form.

 

 


See also:

Managing database registration info

Connecting to databases

Operations with database objects

Selecting multiple objects

Using tabs for database navigation

Recently opened objects

Viewing query history

Managing projects

SQL Assistant

Configuring Database Explorer

Managing Favorite queries