Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    184

    Unanswered: Calendar Functions

    I need to create a report that shows dates mapped to meetings, even when the dates do not have meetings. I'm assuming that I will need to create a calendar table that is populated with all of the dates I will need out into some point in the future.

    Before I go down that path, I just want to make sure that there isn't some built in function to do that for me already in Oracle. Are there any Oracle tricks that make this easier than the way I'm going? Does anyone have script that populates the table?

    Thank you.

    Robert

  2. #2
    Join Date
    Jan 2004
    Posts
    492
    Use this thread, and create the list (probably as an inline view), and outer join them to your other dates. Should work very well as I've used this before.

    http://asktom.oracle.com/pls/ask/f?p...14582643282111
    Oracle OCPI (Certified Practicing Idiot)

  3. #3
    Join Date
    May 2004
    Posts
    184
    Thank you very much. That is exactly what I was looking for!

    Thank you for the quick response.

    Robert

  4. #4
    Join Date
    Jan 2004
    Posts
    492
    Sure thing
    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •