Creating PL/SQL code

You can use either the SQL Worksheet, or the PL/SQL Editor, to create and edit your PL/SQL code. You can think of the SQL Worksheet as a free format text editor where you can create anonymous PL/SQL blocks or more formal structured program units, such as procedures. Using the PL/SQL Editor, you can edit program units already in the database. In either case, SQL Developer provides you with a set of tools to help you create, edit, refactor, and debug your code. Coding assistants, such as code insight, code templates, or code snippets, are available in both the SQL Worksheet and the PL/SQL Code editors. However, feedback on errors is only available in the PL/SQL Code editor. We'll start the section by reviewing some of the code editing options available by initially working in the SQL Worksheet with anonymous PL/SQL blocks.

Writing PL/SQL in the SQL Worksheet

The SQL Worksheet is an excellent scratch pad for working with SQL, SQL*Plus, and PL/SQL, and combinations of these...