Edit PL/SQL Programs

To edit PL/SQL programs in the Code Editor:

1. Select View Connection Navigator.
2. Expand Database and select a database connection.
3. Expand the database connection and select a schema.
4. Expand the schema and find a node with the same name as the object type (for example, Functions or Triggers).
5. Expand the node and double-click the object to open it in the Code Editor.

The Code Editor provides code insight for PL/SQL code. When you type a name followed by a '.', a dropdown menu of valid completions appears:

• Names of subprograms, if a packages name + '.' is entered.
• Names of columns, if a table name + '.' is entered.
• Names of all database objects, if another name + '.' is entered.

To configure code insight:

• You can configure code insight behavior in Tools Preferences Code Editor Code Insight.

Related topics

Creating and Editing PL/SQL Programs

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