Question: 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.

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.

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

Assignment 2 (Due is April 20 th ) Question 1 Identifying Customers Assignment 2 (Due is April 20th) Question 1 Identifying Customers Brewbeans Coffee Company wants to offer an incentive of free...

Identifying Customers Brewbean's wants to offer an incentive of free shipping to customers who haven't returned to the site since a specified date. Create a procedure named PROMO_SHIP_SP that...

sql database Assignment 2 (Due is April 20th) Question 1 Identifying Customers Brewbeans Coffee Company wants to offer an incentive of free shipping to customers who havent returned to the site since...

don't have table structure for 1st question pls help in which way u like to do.. it is important for me to submit the assignment to pass the course. Assignment 2 Question 1 Identifying Customers...

pl /sql Assignment 2 (Due is April 20th) Question 1 Identifying Customers Brewbeans Coffee Company wants to offer an incentive of free shipping to customers who havent returned to the site since a...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Use SQL Developer to complete this and future course assignments. Make sure your access as the user CIS_436 is permitted. If possible, please save a connection to enable the use of the SQL Developer...

Oracle 11g PL/SQL Programming The Brewbeans application contains a page displaying order summary information, including IDBASKET, SUBTOTAL, SHIPPING, TAX, and TOTAL columns from the BB_BASKET table....

Oracle 11g PL/SQL Programming Sometimes Brewbeans customers mistakenly leave an item out of a basket thats already been checked out, so they create a new basket containing the missing items. However,...

Oracle 11g PL/SQL Programming When a product is placed on sale, Brewbeans records the sales start and end dates in columns of the BB_PRODUCT table. A function is needed to provide sales information...

1. What can you infer about this organization and its structure based on the conversation you witness in this video clip? 2. Would you describe this as a mechanistic or organic organization? Explain...

You are the chief financial officer (CFO) of Lorien Company, which is publicly traded. At the annual shareholders meeting you discussed the companys recent reported results. As part of your...

Two companies have identical sales revenue of $15 million. Is it true that both have the same operating income and the same margin of safety? Is it possible that one company has a higher margin of...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Explain why the following statements are false. a. The aggregate-demand curve slopes downward because it is the horizontal sum of the demand curves for individual goods. b. The long-run...

Suppose that the economy is currently in a recession. If policymakers take no action, how will the economy change over time? Explain in words and using an aggregate-demand/ aggregate-supply diagram.

Suppose the U.S. economy begins in long-run equilibrium. Concerns about global climate change cause the government to significantly restrict the production of electricity from fossil fuels. Because...