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

Item Not Null

This is a simple validation to verify a page item must contain a value.

When the create validation wizard is first started, a link appears
below the main region named 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.

Item String Comparison

The Item String Comparison will compare string values and return true or false depending on the type of comparison chosen. If there are two numbers to compare, they must have the same string values.  For example: comparing “100” and “100.00” will not return a status of being the same.  The item string comparison types are pretty much self-explanatory, but where applicable, an example will be provided to help clarify it usefulness.

  • Item in Expression 1 contains at least one of the characters in Expression 2:  This is handy to enforce some type of password security.  For example, an expression of !@#$%^&*()[]? may be entered to enforce that, at least, one of these characters appears in the password.  To make sure a number is also included, a second validation with the expression of 0123456789 could be used.  Some expressions require a comma separated list, but these are not like that, they simply require all the characters with no spaces or commas.

  • Item in Expression 1 contains only characters in Expression 2

  • Item in Expression 1 does NOT equal string literal in Expression2

  • Item in Expression 1 does not contain any of the characters in Expression 2

  • Item in Expression 1 equals string literal in Expression 2

  • Item in Expression 1 is NOT contained in Expression 2

  • Item in Expression 1 is contained in Expression 2

  • Item specified is NOT zero

  • Item specified contains no spaces:  This can be a valuable string comparison.  For example, have you ever created a NOT NULL validation and had users figure out that if they entered a space, they could avoid the NOT NULL error?  Well, using this validation in conjunction with a NOT NULL validation will eliminate this loophole for those clever users.

  • Item specified is NOT NULL or zero:  This can be just as valuable as the previous item.  One thing to keep in mind is another validation may be required to make sure it is a positive number if that is a required validation.

  • Item specified is alphanumeric

  • Item specified is numeric

  • Item specified is a valid date

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.