用SQL怎么实现？？oracle中根据数字20064用一句SQL怎么实现输出下列结果12006001220060023200600342006004[
用SQL怎么实现？？
oracle 中 根据数字2006 4 用一句SQL怎么实现输出下列结果
1 2006001
2 2006002
3 2006003
4 2006004
[解决办法]
SELECT LEVEL, 200600 || LEVEL AS "DATE "
FROM DUAL
CONNECT BY LEVEL < 5
/