 |
|
Oracle Tips by Burleson |
Creating Validations
Creating validations is done from the page
definition page. The example shown below will create a validation to
check the format of a date.
1.
Click on the  in
the Validations area under Page Processing.
2.
Select the Validation Level and click Next. The example
uses Item level validation.
3.
On the Item page, select the Item in the list of options, click
Next.
4.
On the Validation Method page, choose the method that
will be used for the validation. The example uses Regular Expression.
5.
On the Sequence and Name page:
-
Set the Sequence to the order in which
the validation is to execute.
-
Enter a Validation Name. By
default this is the name of the page item being validated.
-
Select the Error Display Location.
-
Click Next.
6.
On the Validation page:
-
Enter a Validate Item. This
should already be filled in with the page item selected in step
three.
-
Enter the validation expression
for the Regular Expression. This example will select the [Date
MMDDYYYY] link as shown in Figure 12.4. Select the  icon
to see the popup window shown in Figure 12.3 for a larger
selection of supplied regular expressions.
-
Enter an appropriate Error
Message.
-
Click Next.
7.
On the Conditions page, create conditions if desired and click
Next.
8.
A link is available on the first page of the Validation wizard
titled Create Multiple, not null validations. This link will navigate
to a page where several not null validations can be created in a
matter of seconds.
The
above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create Dynamic
Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
