google dbms_scheduler On Mon, Nov 14, 2011 at 10:03 PM, SANDEEP REDDY <tosandeepyan...@gmail.com>wrote:
> MAY BE ... > > Can i have some basic material on scheduling a pl/sql program or a > procedure... > > I mean I i created a procedure..How to schedule it daily...Without > user interaction.... > > On Nov 14, 11:49 pm, ddf <orat...@msn.com> wrote: > > On Nov 14, 4:08 am, SANDEEP REDDY <tosandeepyan...@gmail.com> wrote: > > > > > > > > > > > > > > > > > > > > > But Interviewer Asked Me "We Should Not Through Any Query/Procedure/ > > > Anything " The Update should be done automatically. > > > > > I Have a small Doubt: > > > > > Is there any way to create a materialized view with stored procedure/ > > > queries ( which is not a table/structure) That can be updatable. > > > > > Like This....Suggest Me If Wrong... > > > > > CREATE OR REPLACE MATERIALIZED VIEW SAMPLE_EXEC > > > REFRESH FORCE > > > START WITH SYSDATE > > > NEXT SYSDATE+1/24 > > > AS > > > ( > > > EXECECUTE procedurename(Parameters); > > > > > ) > > > > > On Nov 14, 2:39 am, VTR250 <goo...@m-streeter.demon.co.uk> wrote: > > > > > > In Oracle it's DBMS_JOB.SUBMIT. I assume there will be only one job > > > > per day (I can imagine that you might want to have several jobs per > > > > day if you are dealing with a lot of fruit, which is likely). You set > > > > the date for the job to run as whatever 'mature date' is. As Jignesh > > > > Makwana suggested, the procedure executed by the job should scan the > > > > whole table in one go (cursor c_A is select Cust_id, Cust_name, > > > > Loan_Amt, Taken_Date, Mature_Date, Interest Status from A where > > > > Mature_Date <= sysdate and status = 'Open') open c_A for update, and > > > > for each record insert what you want into the other table AND update > A > > > > where current of r_A, set Status = 'Closed'. > > > > > > On Nov 14, 2:37 am, Michael Moore <michaeljmo...@gmail.com> wrote: > > > > > > > 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_sche... > > > > > > > On Sun, Nov 13, 2011 at 6:46 AM, Jignesh Makwana > > > > > <makwanajigne...@gmail.com>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" < > 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 > > > > There is no 'automatic' update absent either a trigger or a scheduled > > job. Both will require PL/SQL code. I think you misunderstood the > > interviewer. > > > > David Fitzjarrell > > -- > 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