Online Documentation for SQL Manager for Oracle

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


Click More buttons... btnMoreButtons on the right side of the toolbar and use the Add or Remove Buttons popup menu items to disable the panel by deselecting 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:

Find Text dialog