KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to write a report that generates summary totals against a table with date ranges for each record. table data: option start_date end_date opt1 6/12/2009 6/19/2009 opt1 6/3/2009 6/13/2009 opt2 6/5/2009 6/6/2009 What I want out is basically this: date option count 6/1/2009 opt1 0 6/1/2009 opt2 0 6/2/2009 opt1 0 6/2/2009 opt2 0 6/3/2009 opt1 0 6/3/2009 opt2 1 I am having a hard time figuring out how to iterate over a date range. I am sure this is some simple cursor that could be created for this but I am at a loss. Preferably in PL/SQL UPDATE: I ended up using the example here to accomplish what I wanted to do. This creates a function that generates a table of dates.
Tags (comma-separated)
Save Edits
Cancel