是否可以在Oracle上的SELECT中执行自动编号序列? [英] It is possible to do a autonumber sequence in a SELECT on Oracle?

问题描述

我需要在Oracle中做一个我不知道怎么做的任务.

I need to do a task in Oracle that I don't know how can I possible do this.

好吧，当我即时定义自动编号序列时，我需要做一个选择.

Ok, I need to do a SELECT when I define a autonumber sequence on-the-fly.

例如:

Select autonumber(1, 9000) as auto from some_table

结果将是

auto
------
1
2
3
4
5
6
7
8
9
10
...
9000

这有可能吗?是否有任何Oracle内置函数可以帮助我做到这一点?

This would be possible to do? Are there any oracle build in function that will help me doing this?

推荐答案

select 
  rownum
from 
  dba_objects, 
  dba_objects
where
  rownum <= 9000;

这篇关于是否可以在Oracle上的SELECT中执行自动编号序列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！