Databases Reference
In-Depth Information
Declarative Validations
APEX 4 introduced declarative validations for Tabular Forms. This feature is quite important since it
saves time while building your applications. Declarative validations can be created on a single column
and are grouped in
•
NOT NULL validations
•
Column String Comparison validations
There are several Column String Comparison validations and you can view them in the Figure 3-11.
Figure 3-11.
Tabular Form validations—Column String Comparison
The current release of APEX does not provide declarative validations outside the scope of a single
column; that type of validation is planned for a future release. If you need such a validation, you will
have to write your own code. We will show how to do that later in the chapter (Custom Coding in
Tabular Forms).
Validations Created by Tabular Form Wizard
After creating a Tabular Form, you will find a couple of validations created by the wizard. An example of
these validations is shown in Figure 3-12.
The APEX wizard will use the table definition and sort out the constraints you defined for your table.
It will create a validation for each single column containing a NOT NULL definition (unless the column
is a primary key used for the DML processes), or for columns of type numeric and columns of type date.
