用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
/
发布时间: 2012-03-04 11:13:33 作者: rapoo
用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
/