View the step-by-step solution to:

I have a question regarding a basic Oracle PL/SQL statement.

I have a 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;
Sign up to view the entire interaction

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question