生成一列编号

select decode(sign(rownum-3),0,rownum,rownum-1) rn
from dual
connect by level < 4

结果：
0
1
3

select rownum from dual connect by level < 4;
结果：
1
2
3