WHERE billtyp = l_type AND refno = l_agtmnt Lastbillraised, noofstaff, items, area, LENGTH, INTO refno, billtyp, ob, status, dueamt, duedate,įrequency, lastrevrate, penaltyamt, accounted, SELECT a.refno, a.billtyp, a.ob, a.status, a.dueamt, a.duedate,Ī.frequency, a.lastrevrate, a.penaltyamt, a.accounted,Ī.lastbillraised, a.noofstaff, a.items, a.area, a.LENGTH, TO_NUMBER ((capcost * rate / 100) + (ob + (ob * interestrate / 100))) Penaltyrate afxbrrate.penaltyrate%TYPE - := 0 Interestrate afxbrrate.interestrate%TYPE - := 0 Lastbillraised afxbrmst.lastbillraised%TYPE Ĭapcost NUMBER afxbrmst.capcost%TYPE :=1 įeamount afxbrrate.feamount%TYPE - := 0 Penaltyamt afxbrmst.penaltyamt%TYPE - := 0 Lastrevrate afxbrmst.lastrevrate%TYPE - := 0 1.7K Training / Learning / Certificationīut i still didn't get my desired solution so i am pasting my whole plsql code here. 165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |