摘要：
--根据日期范围SELECT LEVEL + to_date('20120821', 'yyyy-mm-dd') - 1 FROM dualCONNECT BY LEVEL < to_date('20120831', 'yyyy-mm-dd') - to_date('20120821', 'yyyy-mm-dd') + 2;--根据数据范围SELECT LEVEL + 1-1 FROM dualCONNECT BY LEVEL <= 10; 阅读全文
|
摘要：
--根据日期范围SELECT LEVEL + to_date('20120821', 'yyyy-mm-dd') - 1 FROM dualCONNECT BY LEVEL < to_date('20120831', 'yyyy-mm-dd') - to_date('20120821', 'yyyy-mm-dd') + 2;--根据数据范围SELECT LEVEL + 1-1 FROM dualCONNECT BY LEVEL <= 10; 阅读全文
|