User Details form page is page 1 in your application. On this page the end user is required to
provide his Name and Address details- You need to create a validation that requires the end
user to enter a province if the country is not the United States (US).
Which action needs to be performed?
A.
Create a validation of type SQL and enter the following in the validation method;
SELECT 1 FROM CUSTOMERS
WHERE COUNTRY= ‘US’ AMD PROVINCE IS NULL
B.
Create a validation of type PL/SQL Function Returning Boolean and enter the following in
the validation method:
BEGIB
IF :Pi_COUNTRY = ‘US’ AMD : Pl_PROVINCE IS NULL THEN
RETURM FALSE;
ELSE
RETURN TRUE;
END IF;
END;
C.
Create a validation of type PL/SQL Function Returning Boolean and enter the following in
the validation method;
BEGIN
IF :P1_COUNTRY != ‘US’ AND ; Pl_PROVINCE IS NULL THEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
END;