Write a sub program and call it from the end of the day job so that you do this maturity check only once in a day. On Nov 13, 2011 1:53 PM, "SANDEEP REDDY" <tosandeepyan...@gmail.com> wrote:
> We Are Not Updating AnyThing Inbetween The Duration...But Should Fire > Automatically When Mature Date Reaches....Mind Blowingggg....No Idea's > > > We Can Manually Update Even With Procedures .. But the interviewer > Question Is To fire Automatically WithOut User Interface... > > On Nov 12, 11:19 pm, Michael Moore <michaeljmo...@gmail.com> wrote: > > 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 > -- 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
