PL/SQL

 

The Reporting and Analysis Department has a database containing tables that hold summarized data to make report generation simpler and more efficient. They want to schedule some jobs to run nightly to update summary tables. Create two procedures to update the following tables (assuming that existing data in the tables is deleted before these procedures run):

 

PROCEDURES:

 

Create the PROD_SALES_SUM_SP procedure to update the BB_PROD_SALES table, which holds total sales dollars and total sales quantity by product ID, month and year. The order date should be used for the month and year information.

 

Create the SHOP_SALES_SUM_SP procedure to update the BB_SHOP_SALES table, which holds total dollar sales by shopper ID. The total should include only product amounts—no shipping or tax amounts.

 

The BB_SHOP_SALES and BB_PROD_SALES tables have already been created. Use the DESCRIBE command to review their table structures.

APlusGrades

Not Rated (0)

Status NEW Posted 16 Jul 2017 07:07 AM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer