Question regarding a basic Oracle PL/SQL statement. in the following case statement I need to replace the +14, + 7, +3 with the values that are pulled from a table called checkout_periods with material_type and days being the relevant columns. Any assistance in this coding is appreciated
ELSE
CASE v_material_type
WHEN 'VHS TAPE' THEN v_due_date := p_checkout_date + 14;
WHEN 'DVD' THEN v_due_date := p_checkout_date + 7;
WHEN 'BLU-RAY' THEN v_due_date := p_checkout_date + 3;
END CASE;