Managing database objects

SQL Navigator’s editing tools for database objects are visual: they give you a visual representation of a database object definition. Visual object editors allow you to view database object definitions and create or alter database objects via a point-and-click interface, eliminating the need to remember SQL syntax and write SQL statements manually .

SQL Navigator provides visual editors for the following objects:

$image\Sqln0004.gif$ Constraints

$image\Sqln0004.gif$ Indexes

$image\Sqln0004.gif$ Database Links

$image\Sqln0004.gif$ Indexes

$image\Sqln0004.gif$ Nested Tables

$image\Sqln0004.gif$ Profiles

$image\Sqln0004.gif$ Roles

$image\Sqln0004.gif$ Sequences

$image\Sqln0004.gif$ Stored Programs

$image\Sqln0004.gif$ Synonyms

$image\Sqln0004.gif$ Tables

$image\Sqln0004.gif$ Triggers

$image\Sqln0004.gif$ Users

$image\Sqln0004.gif$ Varying arrays

$image\Sqln0004.gif$ Views

Opening a visual object editor

The Visual Object Editor command on the View menu gives you quick access to all the object editors.

$image\Sqln0009.gif$

$image\Sqln0010.gif$

Opening objects

Common approaches to managing database objects in SQL Navigator are to:

$image\Sqln0004.gif$ Locate an object in the DB Navigator tree and then apply a toolbar or menu function, or double-click to open it in an editor.

$image\Sqln0004.gif$ Locate the object using the Find Objects dialog in the Search menu, which lets you specify a range of search criteria (name, owner, date last modified, and so on).

$image\Sqln0004.gif$ Open an editor of the appropriate type and then locate the object within the editing window.

$image\Sqln0011.gif$

You can use the SQL wildcard character % as part of your search for object names. The wildcard by itself will return all object names meeting the criteria.

To open a database object in a visual editor

Choose one of the following methods.

$image\Sqln0004.gif$ Double-click a database object in the DB Navigator tree, a workspace, or the Find Objects window.

$image\Sqln0004.gif$ From the View menu, choose Visual Object Editor and then pick an editor from the list.

$image\Sqln0004.gif$ From the Functions toolbar, you can open the Trigger editor or the Stored Program editor.

$image\Sqln0004.gif$ From the Object menu, choose Create DB Object, then choose the type of object you want to create.

$image\Sqln0004.gif$ From the Object menu, choose Open DB Object, then specify the schema, a name mask (% by default), and an object type.

To create a database object

$image\Sqln0006.gif$ From the Object menu, choose Create DB Object, and then choose the type of object you want to create.

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:

$image\Sqln0004.gif$ Roles

$image\Sqln0004.gif$ some nodes under Users

$image\Sqln0004.gif$ Datafiles under Tablespaces

$image\Sqln0004.gif$ Redo Log Groups

$image\Sqln0004.gif$ Rollback Segments