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
