Question: 4 . In the following code, identify ( circle or highlight ) examples of these procedural constructs: variable, conditional control statement, reusable / callable program

4. In the following code, identify (circle or highlight) examples of these procedural constructs: variable, conditional control statement, reusable/callable program unit, and an assignment statement.
DECLARE
v_first_name varchar2(40); v_last_name varchar2(40); v_first_letter varchar2(1);
BEGIN
SELECT first_name, last_name INTO v_first_name, v_last_name FROM students
WHERE student_id =105; v_first_letter := get_first_letter(v_last_name); IF 'N'>'v_first_letter' THEN
DBMS_OUTPUT.PUT_LINE('The last name for '|| v_first_name ||''|| v_last_name ||' is between A and M');
ELSE
DBMS_OUTPUT.PUT_LINE('The last name for '|| v_first_name ||''|| v_last_name ||' 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!