Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

→      Validation Method : ITEM string comparison

select items in expressionl  contained items in expression 2

→ In expression 1 Box give the page item without bind variable

→ In expression 2 Box give the data element separated by slash

symbol for example ABC lDEF l GHU etc' VALIDATION

→      Column Page Processing      →      Section Validation

→      Create Validation      →      Item Level Validation →      NExT

→      Identify the item to be validated

→      Pl-STAFF-DOB ( Date of Birth)    NExT

→      Select a validation Method PLlSQL

→      Select the type of PLlSQL validation you wish to create as

PLlSQL Expression NExT

→ Leave the default with respect to sequence, validation name, error display location NExT

In Validation Box

( sysdate - to-date(:pl-staff-dob,'dd-mm-yyyy') ) >=l8

In Error Message Box

l8 YEARS SHOULD have Been COMPLETED BEFORE JOINING IN THIS FIRM click NExT

Under condition Leave the default and Click CREATE

Another validation rule for Pl-STAFF-DOJ

→      At the time of Joining one should have completed l8 years

→      At the time of Joining one should have not exceeded 58 years