Hi,
I have a table of data that gives me a start and end value by date. I need to return all values per day within the range:

eg: my table consists of
MY_RANGE_START_OR_END_NB,SYS_DATE,MY_RANGE_STATUS
1421,12/09/2011 00:00:00,RANGE_END
1418,12/09/2011 00:00:00,RANGE_START
1401,11/09/2011 00:00:00,RANGE_END
1400,11/09/2011 00:00:00,RANGE_START
1390,10/09/2011 00:00:00,RANGE_END
1389,10/09/2011 00:00:00,RANGE_START

my result set should return:
1389, 10/09/2011
1390, 10/09/2011
1400, 11/09/2011
1401, 11/09/2011
1418, 12/09/2011
1419, 12/09/2011
1420, 12/09/2011
1421, 12/09/2011

my current attempt only returns for a single date:
select (select MY_RANGE_START_OR_END_NB from (select table1.MY_RANGE_START_OR_END_NB, table1.SYS_DATE
from TABLE_ONE table1
where table1.MY_RANGE_STATUS = 'RANGE_START'
)) + (level -1)
-- and table1.SYS_DATE like to_date('20110909','YYYYMMDD'))) + (level -1)
from DUAL
connect by level <= (
select t1.MY_RANGE_START_OR_END_NB - t2.MY_RANGE_START_OR_END_NB
from
(select table1.MY_RANGE_START_OR_END_NB, table1.SYS_DATE
from TABLE_ONE table1
where table1.MY_RANGE_STATUS = 'RANGE_END'
) t1,
-- and table1.SYS_DATE like to_date('20110909','YYYYMMDD')) t1,
(select table1.MY_RANGE_START_OR_END_NB, table1.SYS_DATE
from TABLE_ONE table1
where table1.MY_RANGE_STATUS = 'RANGE_START'
) t2
-- and table1.SYS_DATE like to_date('20110909','YYYYMMDD')) t2
)


I know I am missing something....??