Editing Other Database Objects

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

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

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 folder 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 table, see Editing Tables.

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.