SQL Navigator for Oracle 7.4 - Installation Notes

Chat now with support

Find objects in any schema.

What To Search For

You can construct a search argument for any database object.

You can use wild-card characters %" and "_" (according to SQL LIKE operator definitions).
You can filter by schema, object type, date last modified and status.

TIP: To display a dynamic list of all objects in a schema

In DB Navigator, select a schema node in the top level of the DB Navigator tree.
Click Search | Find Objects.

Task	Action
Describe	View a description of object structure ( index, cluster, procedure, function, or package). Use Describe or Auto Describe Tool on the selected object.
Sort	Sort on any column (name, owner, type, creation/modification date, status) in ascending or descending order. Click the column header.
Open the object for editing	Double click on the object. See Visual Object Editors or the Code Editor for more information.
Locate in schema	Display the selected object in DB Navigator. For more information, see Locate In Tree.
Batch selection and update	On selecting multiple objects you can apply commands like Copy Text, Drop, Extract DDL, Compile, Get Metadata, Properties, Send to Code Analysis, Add to Project Manager, Enable, Disable, and Truncate to the entire batch of objects. For more information, see Object Menu. drag the group of objects into a text editor or DB Navigator.

TIP: Other actions are available. Right-click on the object and select a command from the shortcut menu