||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
Item in Expression 1 contains only characters in
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
Item in Expression 1 is NOT contained in
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
above book excerpt is from:
Oracle Application Express
Web Pages with OAE
Michael Cunningham & Kent Crotty
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA