Chapter02-09 - 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;FOR i IN 1..numpayments LOOPpaymentNum := paymentNum +1;
End of preview. Want to read the entire page?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
SQL, Chapter 2, BOOKWOrk, Steve Coogan, idpledge, 9999 99

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture