New and enhanced Visual Object Editors

 

 

SQL Navigators visual object editors have been visually enhanced.

image\Sqln0004.gif All visual object editors feature a standard toolbar at the top of the window and a status line at the bottom.

image\Sqln0004.gif Buttons that duplicated functions available in the main SQL Navigator toolbar have been removed.

image\Sqln0004.gif Available functions and commands may vary according to the Oracle version being used.

image\Sqln0004.gif The Open object dialog now provides a most-recently-used (MRU) object list.

image\Sqln0004.gif There are new editors for Object Types and Profiles.

New edit functions

There are new editors for Object Types and Profiles.

Various object editors have been given new functionality; for example:

image\Sqln0004.gif the Table and Index editors now support all standard data types and user-defined data types, including LOBs (Large Objects), partitions and sub-partitions, and provide tabbed pages displaying indexes, constraints, and dependencies

image\Sqln0004.gif the Role editor displays granted roles and granted privileges at the same time.

image\Sqln0004.gif the View editor has a new Triggers tab that shows the triggers attached to the view. Double-clicking on a trigger name opens it in the trigger editor.

image\Sqln0004.gif the User editor and Role editor are now separate.

All visual object editors allow for entering non-alphanumeric and mixed-case object names.

 

 

image\Sqln0011.gif

 

SQL Navigator does not support working with LOB or Object table columns when using an Oracle 7 client connected to Oracle 8 database. For full functionality, use an Oracle 8 client to connect to an Oracle 8 database.