Summary

SQL Developer supports creating, editing, and compiling PL/SQL code. The SQL and PL/SQL parsing capabilities provided by the tool mean that additional utilities, such as code insight and completion, can be an invaluable resource to developers working with many objects to hand. Utilities as simple as a small dialog, save time by providing frameworks of code, while code templates and code snippets mean that frequently used code is not far out of reach. Using the utilities provided, and adding your own code to them, can be an invaluable coding resource.

In the next chapter, we'll show you the different utilities that SQL Developer provides to help a DBA in his daily work and tune problem areas in the databases.