Consider A Table With Columns
Cust_id Cust_name Loan_Amt Taken_Date Mature_Date 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 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
