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

32-HOW TO CREATE VALIDATIONS

→      Validation Method : SQL (compares page item with a data in table )

→      Select l from staff-mst where staff-code =

:Pl-STAFF-CODE;

It checks whether the data exists in data'

→      Validation Method : PLlSQL (to validate complex logic )

→      begin

if :Pl-STAFF-CATEGORY = 'ADMINISTRATOR' AND  :Pl-STAFF-BASIC-PAY <=20000 THEN

RETURN FALSE; ELSE

RETURN TRUE;

end if;

end;

normally this type of the validation comes under function returning boolean'

→      Validation Method : PLlSQL Expression

NOT ( :Pl-STAFF-CATEGORY = 'ADMINISTRATOR' AND  :Pl-STAFF-BASIC-PAY <=20000  );

→      Validation Method : ITEM NOT NULL

:Pl-STAFF-CATEGORY (in expression l box)

Any column given in expression l box will be checked against not null status and pass the validations'