I have a table attribute which has following columns
attribute_id, work_id, res_id, attr_start_date, attr_finish_date, attr_amount
where attribute_id is Primary key of this table and work_id, res_id are FKs and work_id, res_id makes a unique key.
There are many other columns but I am keeping it simple here.
So in the view I want to see the key columns and amount repeated for date between attr_start_date and attr_finish_date
How do I write this view.. I know this can be done with stored procedure with while loop and/or cursor. But I am interested in doing this as a view rather than PL?SQL block. IS this possible in a view ?
We use Oracle 8.1.7 here.
Can you have a cursor or while loop in Case statement or in creating a view ?