Oracle of dating series

"Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Obviously generating a list 0..364 would work, too, since I could always: Personally, if an application has a need for a list of dates then I'd just create a table with them, or create a table with a series of integers up to something ridiculous like one million that can be used for this sort of thing.

Posterity nothing; that helped me figure out some bizzarely difficult to track down sql commands for TD.

If there is really only one column, the question doesn't make sense.

Indrajit Agasti is working with Cognizant Technology Solutions Ltd, United Kingdom, as a Project Lead and Oracle Developer.

Otherwise, the result has the same day component as ? Also, we need to modify t he ADD_MONTHS and TRUNC functions to calculate the number of rows for a year. the leap year consideration) will be taken care by Oracle. as the First Day of the Month, we will obtain the first day of the next month. The difference between the first day of next month and first day of current month will give us the exact number of days in the current month.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>