With the Schema Browser you can comfortably navigate through the objects defined in the database. The database objects are always displayed under the currently active Connection. This will be selected either via the Connections View dialog, or will be set automatically upon activation of an SQL Editor or Describe Object dialog.
There are three modes available. Treeview, Category (Accordion) and Tabs. You can switch between the modes by clicking the first icon on Schema Browser toolbar.
When Category mode is activated, all Functions, Packages, Types and Java Sources can be found in section Procedures.
Items can be filtered in all three modes. See the T_ string in Filter field:
If you wish to filter objects by schema, click the icon Schema Filter... on Schema Browser toolbar (the Schema Filter is also accessible from Connections View). Then specify what schemas should be used.
Click the icon Show all Schemas on Schema Browser toolbar to show objects from selected schemas.
It is possible to select multiple objects from the same category and select an action for all selected objects.
The Schema Browser also provides the standard functions for each database object (e.g. rename, edit, drop).
When you select a database object, the object properties will be displayed in the Describe Object dialog. If the Describe Object dialog is closed or hidden, click the selected database object to open the dialog.
Procedures, Functions, Packages, Java Sources and Object Types
Public and Private Synonyms
The object lists can be filtered by schema and object name. By default, only objects of the user schema are displayed. To filter, use wildcards in object names.
For all database objects you can define bookmarks that are displayed in a separate section. So, you can have a quick access to database objects that are frequently used.