select * from t1;
ID,REC_DATE,CLOSE_DATE
1,2011-1-10,2011-1-11
2,2011-2-20,2011-2-25
3,2011-3-10,2011-3-15
如何能得到下面的结果?
1,2011-01-10
1,2011-01-11
2,2011-02-20
2,2011-02-21
2,2011-02-22
2,2011-02-23
2,2011-02-24
2,2011-02-25
3,2011-03-10
3,2011-03-11
3,2011-03-12
3,2011-03-13
3,2011-03-14
3,2011-03-15
建表的sql如下:
create table T1(
id number,
rec_date date,
close_date date);
SET DEFINE OFF;
Insert into T1
(ID, REC_DATE, CLOSE_DATE)
Values
(1, TO_DATE('01/10/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/11/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS');
Insert into L5M.T1
(ID, REC_DATE, CLOSE_DATE)
Values
(2, TO_DATE('02/20/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('02/25/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS');
Insert into L5M.T1
(ID, REC_DATE, CLOSE_DATE)
Values
(3, TO_DATE('03/10/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('03/15/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;
|