You could use a cron job which checks the dates, or use the dbms_scheduler http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_sched.htm
On Sun, Nov 13, 2011 at 6:46 AM, Jignesh Makwana <[email protected]>wrote: > > 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" <[email protected]> > 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 <[email protected]> wrote: >> > use an 'after update' trigger. >> > >> > On Sat, Nov 12, 2011 at 5:40 AM, SANDEEP REDDY < >> [email protected]>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 [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 >> >> -- >> 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 >> > -- > 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 > -- 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
