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.

Here is how the data looks -

attribute_id, work_id, res_id, attr_start_date, attr_finish_date, attr_amount

1 1 2 10/10/01 10/18/01 10
2 2 3 10/13/01 10/15/01 20
3 3 3 10/09/01 10/20/01 11
4 3 2 10/10/01 10/20/01 16

I want to create a view which will give me results like this...
I will just do it for 1 st row.

attribute_id, work_id, res_id, date , amount

1 1 2 10/10/01 10
1 1 2 10/11/01 10
1 1 2 10/12/01 10
1 1 2 10/13/01 10
1 1 2 10/14/01 10
1 1 2 10/15/01 10
1 1 2 10/16/01 10
1 1 2 10/17/01 10
1 1 2 10/18/01 10

So in the view I want to see the key columns and amount repeated for date between attr_start_date and attr_finish_date
(inclusive).

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 ?

Is this possible by doing joins/ subquery ?

Thanks
Sonali