||Oracle Tips by Burleson
Validations are used to check the validity of data entered into
the page items. Validations are used to make sure a mandatory
field has data; a number field, such as currency, actually has a
numeric value; that dates fall into an acceptable range; and
much more. When creating validations, properties are set to
define what page item(s) will be set, when the computation will
be executed, and how.
: A validation specific to a single
item on an application page.
: A validation usually used to check
multiple items on an application page. Often this is a PL/SQL
function used to validate the data before an INSERT or UPDATE
is attempted by a Process. HTML DB uses this kind of
validation to make sure the query entered into a Report region
is a valid query.
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