Editing Other Database Objects

You can edit these online database objects directly through the Connections Navigator if you have administrator privileges:

• PL/SQL triggers, functions, procedures, packages and package bodies
• Object types (UDT)
• Sequences
• Synonyms
• Tables
• Views

To edit a PL/SQL program or object type:

1. Select View Connection Navigator.
2. Expand Database and select a database connection.
3. Expand the schema and the node of the schema object type you wish to edit.
4. Double-click the object you wish to edit.
5. The appropriate code editor appears. Edit the code defining the object.
6. Save the file and close the editor when you are finished .

To edit a sequence, see Editing Sequences.

To edit a synonym, see Editing Synonyms .

To edit a table, see Editing Tables.

To edit a view, see Editing Views.

To edit any object including those not listed above, use the SQL Worksheet.

Related topics

Creating, Editing, and Dropping Schema Objects

Copyright © 1997, 2004, Oracle. All rights reserved.