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

Home
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


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

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

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

 
 
 

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.