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

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

→      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