The Oracle DDL script generation is based on the Velocity engine. It provides the ability to change the generated DDL script by changing the velocity template. We explain how the Oracle DDL generation works in our modeling tools and how to change the template for some specific things.
Knowledge of the Velocity Template Language is necessary for understanding, editing, or creating templates. The Velocity documentation can be downloaded from http://click.apache.org/docs/velocity/VelocityUsersGuide.pdf.
For more information about Oracle DDL 11g, see http://docs.oracle.com/cd/E25054_01/server.1111/e25789/sqllangu.htm.
The modeling tool Oracle DDL generation consists of the following three components:
- The Velocity engine. Oracle DDL generation is performed by the Velocity engine. The engine collects context variables and mergers them into a template.
- The template. The template is a user-defined document that provides the Velocity Template Language (VTL) syntax. The VTL syntax is used to manipulate the context variables for generating the text script. The template file can be changed in the CG Properties Editor dialog box (in the Oracle DDL set shortcut menu, choose the Properties command). The default Oracle DDL template is stored in <program installation folder>\data\DB_engineering\Oracle_template folder.
- Context variables. Context variables are models (retrieved from OpenAPI), code engineering set information, and user-defined variables.
To identify the Oracle object, check applied Stereotypes and Tagged Values.