Question: Create a stored procedure that uses a cursor to iterate through all of the films in the film table and update the rental _ duration

Create a stored procedure that uses a cursor to iterate through all of the films in the film table
and update the rental_duration values. For durations <=4, set the rental duration to 3. For
durations between 5 and 7 set the duration to 5. For durations >=8, set the duration to 6. Be
sure to use proper error handling and transaction processing in your stored procedure. Paste
the stored procedure below and show the durations from the following films to test your stored
procedure.
a.9
b.13
c.32
d.36
e.95
f.105

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 Programming Questions!