Quickly find objects in any schema
The Find Objects feature in the Search menu lets you quickly find objects in any schema. It displays a sortable list based on your search arguments.
The Find Objects dialog
Find objects from stored programs or scripts
To instantly find objects from stored programs or scripts, and open them in the Visual Editors, use the Open Object at Cursor command in the Edit menu.
Describe and Auto Describe
You can view a description of object structure simply by right-clicking a table, index, cluster, procedure, function, or package and choosing Describe from the shortcut menu. Or, open the Auto Describe tool and then select an object.
Launching the DESCRIBE window from the DB Navigator
Oracle Data Dictionary views
By default, SQL Navigator gives you USER object data dictionary views, meaning you can see only objects you own or for which you have been granted object privileges. You can select Enable using DBA dictionary views under View>Preferences>Session if you want to see all objects available under your DBA user privileges. DBA dictionary views are required for editing Profiles, Roles, and Users, or for viewing the following nodes of the DB Navigator tree:
Roles
some nodes under Users
Datafiles under Tablespaces
Redo Log Groups
Rollback Segments
Search filters
You can filter your search results by specifying name or owner/name template (including wild-card characters), type, date last modified, or status.
Sorted results
Search results can be sorted on any column (name, owner, type, creation/modification date and status) in ascending or descending order, simply by clicking the column header, or a shortcut menu item.
Optional detail view
The list can be viewed with or without details—similar to the way the Windows Explorer window works.
Double-click anywhere to edit
When you double-click on a displayed object, Navigator automatically opens it for editing.
Locate in schema
You can use the Locate in Schema command to display the selected object in DB Navigator.
Batch selection and update
When multiple objects are selected, you can apply commands like Copy Text, Drop, Extract DDL, Compile, Enable, Disable, and Truncate to the entire batch of objects.