use an 'after update' trigger. On Sat, Nov 12, 2011 at 5:40 AM, SANDEEP REDDY <tosandeepyan...@gmail.com>wrote:
> 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 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 > -- 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
