Newsletters Archive - 2006

If you would like to know more about the iDevelopment.info Newsletter, please email me.


  Date Arithmetic in Oracle - Expressing Time with Fractions — (14-June-2006)

Anyone who has had to work with scheduling jobs in Oracle knows the frustration 
of having to deal with calculating a job's next date and internal using Oracles 
date arithmetic. This month I have made several updates to an already popular 
article that demonstrates the basics of representing time using Oracle's date 
math along with many useful examples. Although many of the examples are based on 
scheduling tasks to maintain and manage Statspack, they can be expanded to 
support any type of scheduled job.

The newly updated article can be found at:

http://www.idevelopment.info/data/Oracle/DBA_tips/SQL/SQL_4.shtml

----------------------------
Jeffrey M. Hunter
Sr. Database Administrator
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------