SQL ORACLE QUESITON HELP ( NEED DONE IN THE NEXT 10 HOURS)
Task 2. Anonymous blocks, explicit Cursors and %ROWTYPE
Write a PL/SQL program that lists those customers who have rented any type of VHS tape in August 2011. In your output, list those customers sorted ascending by lastname, and then after each customer, list the items that they rented in that month (ie. August 2011), separated from the customer name and address by a blank line. Include the item identifier, item title, item type (XBOX, VHS) and the rental date of each item rented by that customer.
Hint : Compare the ‘VHS’ items types to the rental_item_type column
You may use explicit, implicit, complex queries, or a combination of all three to compute the result. When using any cursor, however, you must use %ROWTYPE to declare the structure required to temporarily store the information for each customer or item.
Create a script file (Ch2Task2MA.sql) to display the required data. Submit a printed copy of both your completed script file and its corresponding output file (Ch2Task2MA.out).