Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  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  

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.