Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: (month is february and year is leap) job scheduling DBMS_JOB with oracle 9I
Hi,
Use Last_day function to find Last day of current month.
Then make a small procedure to transfer data to one table to another
table.
Then use that in dbms_job
Exa.
select last_day(sysdate) from dual;
Received on Fri May 05 2006 - 05:19:02 CDT