Question: 4 . In the following code, identify ( circle or highlight ) examples of these procedural constructs: variable, conditional control statement, reusable / callable program
In the following code, identify circle or highlight examples of these procedural constructs: variable, conditional control statement, reusablecallable program unit, and an assignment statement.
DECLARE
vfirstname varchar; vlastname varchar; vfirstletter varchar;
BEGIN
SELECT firstname, lastname INTO vfirstname, vlastname FROM students
WHERE studentid ; vfirstletter : getfirstlettervlastname; IF Nvfirstletter' THEN
DBMSOUTPUT.PUTLINEThe last name for vfirstname vlastname is between A and M;
ELSE
DBMSOUTPUT.PUTLINEThe last name for vfirstname vlastname is between N and Z;
END IF; END;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
