Consider A Table With Columns
Cust_id Cust_name Loan_Amt Taken_Date Mature_Date Principle_Interest Status ----------- ---------------- -------------- ----------------- ------------------ ------------------------- ---------- 1 Apple 10000 15-02-2009 28-04-2011 8.5% Open 2 Banana 25000 26-04-2010 17-09-2011 9% Open I Want The table to be updated implicitly when mature_date=sysdate with following Output Inserted In Another Table.. Cust_Id Loan_Amt Interest_Rate Duration Total_amt ----------- ---------------- -------------------- ------------ --------------- 1 10000 8.5 180 (180/365)*1.85 <---For Example And The Status Should Be Closed After Calculating.. This has To Be done Without Any User Interface... I Am Unable Solve This Query... Help Me Thanks In Advance -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
