The central feature of the SQL Navigator interface is its hierarchical view of the relational database structure, called the DB Navigator.
Use the DB Navigator window for fast and powerful database browsing and drill-down. DB Navigator combines the advantages of the Windows Explorer and a Web browser.
DB Navigator displays all types of Oracle 8 and 8i objects, giving you a hierarchical view of any schema, including dependant objects.
Tree view and detail view
DB Navigator lets you view database objects in a two-pane window—a tree view on the left, and a list view on the right. When you select a Schema node or Object Type node (for example, Table or Index) in the left pane, the right pane shows a list of objects contained in that node.
When you select a specific object in the left pane, the list view pane shows you a list of the attributes of the object you selected.
If the right pane is hidden, you can show it by either of the following methods:
To show or hide the DB Navigator details pane
Click 
on the DB Navigator toolbar
—Or—
Right-click in the DB Navigator window and choose View 
Show/Hide Details from the shortcut menu.
Display and selection options
The list of objects in the right pane is displayed when the selected node in the tree is a container of objects (such as the Tables node under a schema) and it has been expanded.
The list can be displayed as a simple list of names or a detailed multi-column report showing all known properties of the objects.
Click an object in the tree to view the object’s properties.
This list allows for selection of multiple objects for batch operations like Drop, Extract DDL, or Compile.
Data Dictionary views
DBA views are required for viewing some objects.
