PL/SQL Developer - Templates


Templates are a powerful feature to quickly insert standard SQL and PL/SQL code into an editor, or to create a new program unit. This will not only save time (you don't need to lookup the syntax anymore), but it will also enforce standardization.

PL/SQL Developer comes with a number of pre-defined templates, but you can also define your own templates. They are organized in a hierarchical structure, so that you can easily find the template you need.

A template can prompt a user to specify the values of certain variables. These variables can be represented as check boxes and suggestion lists, which in turn can be populated by queries. You can also use pre-defined variables such as the date, time, user, and so on.