About PL/SQL Code Editor

Use the PL/SQL Code Editor to edit triggers, procedures, functions, packages, and package bodies. The PL/SQL Editor is database-backed, as opposed to file-based. Changes are saved to the Oracle Database. For file-based editing, such as editing SQL scripts, please use the Oracle SQL Editor.

To start the PL/SQL Code editor, see Starting the PL/SQL Code Editor.

The PL/SQL Code Editor provides several features that help you to quickly and efficiently write PL/SQL code, which include quick access to help information about the PL/SQL or SQL command you are entering.

After you edit and compile or save the PL/SQL code, Oracle Developer Tools commits the updated changes to the database.

You can use the Oracle PL/SQL Debugger to debug PL/SQL code.