Oracle 11g PL/SQL Programming

Brewbeans wants to offer an incentive of free shipping to customers who havent returned to the site since a specified date. Create a procedure named PROMO_SHIP_SP that determines who these customers are and then updates the BB_PROMOLIST table accordingly. The procedure uses the following information:

Date cutoffAny customers who havent shopped on the site since this date should be included as incentive participants. Use the basket creation date to reflect shopper activity dates. MonthA three-character month (such as APR) should be added to the promotion table to indicate which month free shipping is effective. YearA four-digit year indicates the year the promotion is effective. promo_flag1 represents free shipping.

The BB_PROMOLIST table also has a USED column, which contains the default value N and is updated to Y when the shopper uses the promotion. Test the procedure with the cutoff date 15-FEB-12. Assign free shipping for the month APR and the year 2012.