Chapter02-10 - Copy.sql - DECLARE-Declare variables numpayments NUMBER(2 paymentNum NUMBER(2 sdate DATE dateDue DATE monthlyPaymentAmt NUMBER(10,2

Chapter02-10 - Copy.sql - DECLARE-Declare variables...

This preview shows page 1 out of 1 page.

DECLARE--Declare variablesnumpayments NUMBER(2);paymentNum NUMBER(2);sdate DATE;dateDue DATE;monthlyPaymentAmt NUMBER(10,2);donationBalance NUMBER(10,2);pamt NUMBER(10,2); BEGIN--Prompt user for IDPledgeSELECT PLEDGEAMT, PLEDGEDATE, PAYMONTHS INTO pamt, sdate, numpaymentsFROM DD_PLEDGEWHERE IDPLEDGE = &IDPLEDGE;monthlyPaymentAmt := pamt / numpayments; dateDue := sdate;donationBalance := (pamt - monthlyPaymentAmt);paymentNum := 0;

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture