Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> (month is february and year is leap) job scheduling DBMS_JOB with oracle 9I
hello,
I am developing an application in which i need to transfer data from one table to another table within same schema in ORACLE 9i.
transfer period = month end (12:00 am)
i.e. data will be transfer on last date of every month at 12:00 mid
night
e.g. IF month is janaury then transfer at 31-01-06 (12:00 am) month is february then transfer at 28-02-06/29-02-06 (12:00 am) month is march then transfer at 30-01-06 (12:00 am) --
----
----
and so on.............
could anyone suggest..........
send me mail on
sanjeev_atvankar_at_yahoo.co.in
Received on Fri May 05 2006 - 05:10:16 CDT